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
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
thisindex. 
>
> Thanks,
> Si
>
> _____________________________________________________________
> Pick up your email anywhere in the world ---> http://www.remail.net
>