Thread: autoincrement
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 autoincrementfield?" Thanks a lot. -- green [http://www.extrasy.net]
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. > > -- > green > [http://www.extrasy.net] > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
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