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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
