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
>