Just off the top of my head...so please forgive any typos or blatant
mistakes...
CREATE SEQUENCE sequencename;
CREATE TABLE mytable (
id int DEFAULT NEXTVAL('sequencename'),
whatever varchar(32),
PRIMARY KEY(id)
);
Doug
At 11:28 PM 4/13/01 -0600, John Starkey wrote:
>I've been using mysql too much lately.
>
>Can anyone tell me how to set up an auto increment in postgres? I need
>to select a row based on a user's menu selection. Requiring them to type
>in a text entry and get it right would obviously be pretty inefficient.
>
>Thanks,
>
>John
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
