Postgres Pro
Downloads
Home   >   mailing lists

Re: create table as select... with auto increment id ? - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: create table as select... with auto increment id ?
Date
Msg-id CAEYLb_VZW92gjo_wxHhsOQ3F4RWBArBWiVs49wTeajRZxR9qSw@mail.gmail.com
Whole thread Raw
In response to create table as select... with auto increment id ?  (David Salisbury <salisbury@globe.gov>)
List pgsql-general
Tree view 
On 26 July 2011 01:17, David Salisbury <salisbury@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

pgsql-general by date:

Previous
From: David Salisbury
Date:
Subject: create table as select... with auto increment id ?
Next
From: Joe Conway
Date:
Subject: Re: create table as select... with auto increment id ?