Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I wanna ask how to select coloum 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

share|improve this question

1 Answer 1

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.

share|improve this answer
dba.stackexchange.com/questions/47098/… (self plug!) –  dezso Jul 3 '14 at 14:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.