Re: Auto incrementing an integer

Thanks Mart�n....I found this http://dis.lib.muohio.edu/code/entry.html?ID=3

Creating an Autoincrement field in Postgresql
 postgres does this a little differently; the "serial" type creates an
integer column, and a sequence used to increment this column.

try this:

create table table_name(control serial,another_column text,primary key(control)
);

results in this:
Table    = table_name
+----------------------------------+----------------------------------+-----
--+
|              Field               |              Type                |
Length|
+----------------------------------+----------------------------------+-----
--+
| control                          | int4 not null default nextval('" |
4 |
| another_column                   | text                             |
var |
+----------------------------------+----------------------------------+-----
--+
Index:    table_name_pkey