Re: Auto incrementing an integer

Thanks Martn....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