Antw: Automatic index numbers - Mailing list pgsql-sql

From Gerhard Dieringer
Subject Antw: Automatic index numbers
Date
Msg-id s923af60.091@kopo001
Whole thread Raw
List 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




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using substr with user defined types
Next
From: christine@observatoiredesmarques.fr
Date:
Subject: Translaye from Oracle