Skip site navigation (1) Skip section navigation (2)

Antw: Automatic index numbers

From: "Gerhard Dieringer" <DieringG(at)eba-haus(dot)de>
To: <daniel(at)clacknet(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Antw: Automatic index numbers
Date: 2000-05-18 06:52:32
Message-ID: s923af60.091@kopo001 (view raw or flat)
Thread:
Lists: pgsql-sql
>>> daniel(at)clacknet(dot)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

Next:From: christineDate: 2000-05-18 09:21:01
Subject: Translaye from Oracle
Previous:From: Tom LaneDate: 2000-05-18 03:18:54
Subject: Re: pg_dump return failed sanity check

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group