From: | si <s(at)remail(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | indexing |
Date: | 2001-02-26 15:04:50 |
Message-ID: | 20010226150451.3ABA636F9@sitemail.everyone.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-02-26 16:50:16 | Re: indexing |
Previous Message | Jaume Teixi | 2001-02-26 13:28:58 | COPY doesn't works when containing '' or '' characters on db |