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 <green@usa.dp.ua> wrote:
> 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.
>
> --
> green
> [http://www.extrasy.net]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Aasmund Midttun Godal
aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46