Re: Equivalent for AUTOINCREMENT?

# create table foo( a SERIAL );
NOTICE: CREATE TABLE will create implicit sequence "foo_a_seq" for serial column "foo.a"
CREATE TABLE

# \d+ foo
  Table "public.foo"
 Column | Type | Modifiers | Description
--------+---------+-------------------------------------------------+-------------
 a | integer | not null default nextval('foo_a_seq'::regclass) |
Has OIDs: no

AUTOINCREMENT has so many problems, that soon you'll start to love sequences so much, you'll start to hate mysql's childlish approach to problem solving :)

Also make sure you read carefuly: http://www.postgresql.org/docs/8.3/static/sql-createsequence.html