On 17/05/2011 16:26, Carlos Mennens wrote:
On Tue, May 17, 2011 at 11:22 AM, Jaime Casanova<jaime@xxxxxxxxxxxxxxx> wrote:
in postgres is as easy as
CREATE TABLE test(
id SERIAL PRIMARY KEY);
hey! it's even less keystrokes!
I don't understand how this command above is associated with being
able to auto increment the 'id' column. Sorry I'm still learning a
lot...
Well, the SERIAL pseudo-type creates the sequence, associates it with
the column, and sets a DEFAULT on the column which executes the
nextval() function on the sequence - all in one fell swoop. Read all
about it here:
http://www.postgresql.org/docs/9.0/static/datatype-numeric.html#DATATYPE-SERIAL
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
