create table xxx (id serial) is the easy way.
Dave
----- Original Message -----
From: "K Old" <kevsurf4@hotmail.com>
To: <pgsql-general@postgresql.org>
Sent: Monday, April 23, 2001 6:22 PM
Subject: [GENERAL] Auto increment?
> Hello all,
>
> Any ideas how I can duplicate the auto increment feature that MySQL uses
in
> PostgreSQL? (Other than doing a query to find the next number in que)
>
> Just thought I'd ask.
>
> Thanks,
> Kevin
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>