Re: auto_increment

MySQL: create table foo ( id int not null auto_increment primary key, state enum('enabled', 'disabled') ); PostgreSQL: create table foo ( id int not null primary key default nextval('foo_id_seq'), state varchar(8) check (state in ('enabled', 'disabled')) ); create sequence foo_id_seq; select setval('foo_id_seq', (select max(id) from foo)); More: http://www.ca.postgresql.org/docs/faq-english.html#4.15.1 -- Kind regards,Yuri. >>>> www.AceHoster.com <<<< Quality web hosting "Webmaster" <webmaster@harbornet.com> > I'm using PHP v.4.0.6. and PostgreSQL 7.2. Does any one know the > equivilant of auto_increment for postgresSQL? For example when creating > a table: > > $query = "CREATE table $tablename (id INT UNSIGNED NOT NULL > AUTO_INCREMENT PRIMARY KEY, firstname TEXT, lastname TEXT, emailaddress > TEXT, )"; > > this works fine in MySQL, but I keep getting errors with PostgreSQL. > > thanks for any help, > -Elkan >