indexing - Mailing list pgsql-admin

From si
Subject indexing
Date
Msg-id 20010226150451.3ABA636F9@sitemail.everyone.net
Whole thread Raw
Responses Re: indexing  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: indexing  (Jeff Duffy <jduffy@greatbridge.com>)
List pgsql-admin
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
timethe data is entered and find out the highest number then increment it by 1 and then enter the data with the
incrementednumber. 

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

pgsql-admin by date:

Previous
From: Katsuyuki Tanaka
Date:
Subject: IPC Shared Memory (fwd)
Next
From: Stephan Szabo
Date:
Subject: Re: indexing