Обсуждение: auto increment primary key
I created a table, want the integer/varchar primary key column to be incremented automatically when inserted a new row. How do I define the table to do that? I tried AUTO_INCREMENT and INCREMENT but postgres accept none of them. Thanks NJ __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/
On Fri, Apr 05, 2002 at 02:21:19AM -0800, impala wrote: > I created a table, want the integer/varchar primary > key column to be incremented automatically when > inserted a new row. How do I define the table to do > that? I tried AUTO_INCREMENT and INCREMENT but > postgres accept none of them. create table foo ( bar serial primary key, . . . This implies the creation of a special table called a sequence which does the auto-incrementing. Regards, Frank
----- Original Message ----- From: "impala" > I created a table, want the integer/varchar primary > key column to be incremented automatically when > inserted a new row. How do I define the table to do > that? I tried AUTO_INCREMENT and INCREMENT but > postgres accept none of them. > search docs for "sequence" and "serial" how do u increment a varchar? Marin ---- "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. "