RE: help with serial type - Mailing list pgsql-general

From
Subject RE: help with serial type
Date
Msg-id 371EAC487A83CD4296F6999FD088D8331B700C@atlas.managestar.com
Whole thread Raw
In response to help with serial type  (Jason <gee308@mediaone.net>)
List pgsql-general
Try this command at the psql command line:

CREATE SEQUENCE atable_id_seq;
ALTER TABLE atable ALTER COLUMN id SET DEFAULT
nextval('"atable_id_seq"'::text);

Jeff

-----Original Message-----
How can I make the insert
command automatically update the 'id' to the next highest number?

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: JDBC speed question.
Next
From: Doug McNaught
Date:
Subject: Re: JDBC speed question.