Re: indexing

Use an sequence.  Add the ID column to your create table statement and set
the default to use the next value from the sequence.  This will give each
entry a unique id number.  The syntax would be as follows.

create sequence customer_id start 1 increment 1 maxvalue 2147483647 minvalue
1 cache 1;

create table customer(
  cust_id int unique not null default nextval('customer_id'),
  last_name varchar(....
)

This will create a database sequence, and then each time you insert a
customer, if you don't specify a cust_id, it will default to the next value
in the sequence.

Tim White

----- Original Message -----
From: "si" <s@remail.net>
To: <pgsql-admin@postgresql.org>
Sent: Monday, February 26, 2001 9:04 AM
Subject: [ADMIN] indexing


> Hi,
>
> I am new to postgresql, Please can you guide me:
>
> I have created a table and I would like all the entries to be indexed with
a number when the data is entered into the database, hence giving it a new
id, every time some data is entered.
>
> e.g.
>
> I.D.    |   Name
> 1       |   Jack
> 2       |   Jill
>
>
> Does pgsql do this automatically? or do I have to create a seprate ID
field like above, and check the database each time the data is entered and
find out the highest number then increment it by 1 and then enter the data
with the incremented number.
>
> If it automatically indexes the names when they are entered in to the
database, Please can you show me how to find this index.
>
> Thanks,
> Si
>
> _____________________________________________________________
> Pick up your email anywhere in the world ---> http://www.remail.net