Re: indexing

You can use the serial type to make the id,
although serial only guarantees uniqueness
not sequential numbers. something like:

create table foo (
id serial primary key,
name text
);


On Mon, 26 Feb 2001, si wrote:

> 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
>