Re: Automatic index numbers

From: Kees Kuip <keeskuip(at)technologist(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Automatic index numbers
Date: 2000-05-24 19:38:26
Message-ID: 392C2FB2.FBF1C325@technologist.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Daniel Mendyke wrote:
>
> How can I automatically create a unique index
> number when I add new data to a table?
>

Try

CREATE TABLE test
(
id serial
)

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2000-05-24 21:04:06 Re: Why is PostgreSQL 7.0 SQL semantics different from Oracle's?
Previous Message Thomas Holmgren 2000-05-24 17:58:59 Why is PostgreSQL 7.0 SQL semantics different from Oracle's?