On 26 July 2011 01:17, David Salisbury <salisb...@globe.gov> wrote: > I work with rails developers and they are fussy about having an > auto incrementing "id" field. Is there a way I can eak that out > of the above type statement, or am I stuck with creating the > table and no short cuts? > > create table freaky ( id autoincrement, and-a-long-list int, > and-perfect-order float ) > insert into freaky as select "abunchofstuff-in-same-order" > > I think I know the answer ;-<
http://wiki.postgresql.org/wiki/FAQ#How_do_I_create_a_serial.2Fauto-incrementing_field.3F Hope that helps -- Peter Geoghegan http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
