0

I want to know how to select values from a column that has SERIAL data type.

I already try to do that but the output is like this 'Resource id #3', and not just '3'

I use SERIAL so I dont have to input ID like when I use integer

ypercubeᵀᴹ
  • 97,895
  • 13
  • 214
  • 305
user42121
  • 1

1 Answers1

2

There is no actual serial data type. serial is just a notational convenience.
The resulting data type is integer for serial or bigint for bigserial

Related answer on SO with more details:
Auto increment SQL function

You'd have to be more specific for a more specific answer.

Community
  • 1
Erwin Brandstetter
  • 175,982
  • 27
  • 439
  • 600
  • 3
    http://dba.stackexchange.com/questions/47098/how-do-i-determine-if-a-column-is-defined-as-a-serial-data-type-instead-of-an-in (self plug!) – András Váczi Jul 03 '14 at 14:51