Yep, use the serial datatype. And then use the helpful documention. :) http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-SERIAL http://www.postgresql.org/docs/faqs/FAQ.html#4.15.2
On Fri, 13 Aug 2004 [EMAIL PROTECTED] wrote: > Hi I'm a newbie in postgresql, I came from MSSQL, MySQL and now > I'm testing postgres. > In mysql there is a way to make a second autoincrement field, just: > > create table table1 > (field1 integer, > field2 integer autoincrement, > primary key (field1,field2)) > > when insert rows: > > insert into table1 (field1) values (1); > insert into table1 (field1) values (1); > insert into table1 (field1) values (2); > > and then select * from table1, you get: > field1| field2 > ------+------- > 1 | 1 > 1 | 2 > 2 | 1 > ------+------- > > there is a way to do this with postgres??? > > thnx!!!! > > -- > Saludos, > adburne > mailto:[EMAIL PROTECTED] > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
