Creating auto-increment primary key 1

[Guest_imported]

I want to create a table in wich its primary key will be auto incremented.

I tried

CREATE TABLE table_name (id INT, name TEXT, PRIMATY KEY id AUTO_INCREMENT);

but that doesn´t work.

 

[SteveBrett]

choose serial as the datatype

this will create a sequence and the next vlaue of the serial will be set to that.

sequences can be listed by using \d s

the default for the serial will be set to nextval('sequence name')

 

[Guest_imported]

This is it:

CREATE TABLE table_name (id SERIAL);