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, whole thread or download thread mbox)
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')


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-2017 The PostgreSQL Global Development Group