auto_increment

I'm looking for the query for auto_increment in postgreSQL. Please help me if you know.

Thanks a lot!

keyword -> 'sequences'

In other words, zalew means go to this page and enter 'sequences' in the search bar at the top. The first two entries should be about sequence-manipulation and the CREATE SEQUENCE command.

Also, though, when creating a table, if you use the datatype SERIAL for a column, that is a shortcut which creates a named sequence for that column of that table, and creates a default value of "nextval('sequence_name'" for that column. If you want your auto_incremented column to be a long integer (if you need more than 2 billion rows), use SERIAL8.