Re: [GENERAL] create table as select... with auto increment id ?

2011-07-25 Thread Joe Conway
On 07/25/2011 05:17 PM, David Salisbury wrote: > > We all know i can > > create table freaky as select "abunchofstuff". > > 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 st

Re: [GENERAL] create table as select... with auto increment id ?

2011-07-25 Thread Peter Geoghegan
On 26 July 2011 01:17, David Salisbury 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

[GENERAL] create table as select... with auto increment id ?

2011-07-25 Thread David Salisbury
We all know i can create table freaky as select "abunchofstuff". 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 f