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
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 only takes a minute to sign up.
Sign up to join this communityThere 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.