Just off the top of my head...so please forgive any typos or blatant

CREATE SEQUENCE sequencename;
CREATE TABLE mytable (
  id int DEFAULT NEXTVAL('sequencename'),
  whatever varchar(32),


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.

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]

Reply via email to