Re: Strategy for Primary Key Generation When Populating Table - Mailing list pgsql-general

From Rich Shepard
Subject Re: Strategy for Primary Key Generation When Populating Table
Date
Msg-id alpine.LNX.2.00.1202091249550.5256@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Strategy for Primary Key Generation When Populating Table  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
On Thu, 9 Feb 2012, Andy Colson wrote:

> If you create a serial column, dont put the column name or a value into your
> insert statement.
>
> create table junk (id serial, stuff text);
> insert into junk(stuff) values ('my stuff');

Andy,

   That's what I assumed would work but did not know for sure.

Thanks,

Rich


pgsql-general by date:

Previous
From: Gary Chambers
Date:
Subject: Re: Warning: you don't own a lock of type ExclusiveLock
Next
From: Daniel Vázquez
Date:
Subject: initdb $PGDATA not working