SERIAL type (look it up in the docs).
Regards,
Aasmund
PS. I may not be good at counting, but I have counted your two words 3 times and I
still get 6.
On Thu, 25 Oct 2001 23:09:32 +0300, Alexey Prohorenko <[EMAIL PROTECTED]> wrote:
> How can I reproduce in PostgreSQL type structure fr
Use SERIAL instead of AUTO_INCREMENT.
> How can I reproduce in PostgreSQL type structure from MySQL:
> INT NOT NULL PRIMARY KEY AUTO_INCREMENT
>
> ?
>
> To be more exact -- in two words: "how can I create autoincrement
> field?"
>
> Thanks a lot.
>
> --
>
On Tue, 2 Jan 2001, Macky wrote:
> Is there a function in SQL that does autoincrementing...
http://www.postgresql.org/docs/faq-english.html#4.16.1
and
http://www.postgresql.org/users-lounge/docs/7.0/postgres/sql-createsequence.htm
will tell you how to do this.
-- Brett
