Antw: Automatic index numbers

Gerhard Dieringer <dieringg@eba-haus.de>

From: "Gerhard Dieringer" <DieringG@eba-haus.de>
To: <daniel@clacknet.com>, <pgsql-sql@postgresql.org>
Date: 2000-05-18T06:52:32Z
Lists: pgsql-sql
>>> daniel@clacknet.com 18.05.2000  02.52 Uhr >>>
>
> How can I automatically create a unique index
> number when I add new data to a table?
>
> Does this have to be done through a high level
> language or does the database provide a function
> for this?
> 
> -Daniel

You can use a column with datatype serial or an integer with default nextval('a_sequence')

Gerhard