Using Indices

From: Alexander Lohse <al(at)humantouch(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Using Indices
Date: 2001-04-01 15:37:07
Message-ID: p05010400b6ecfaec0a5d@[192.168.0.44]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

when I use phpPgAdmin to create DBs, my Indices are getting automatic
names like : pers_UID_key

I am getting confused about the name!

Does that mean a need to do call this in a select query?

"select * from pers where pers_UID_key = '...'"

or do i call the original field?

"select * from pers where UID= '...'"

Thanx,

Alex
--
___________________________
Alexander Lohse
Human Touch Medienproduktion GmbH
Am See 1
17440 Klein Jasedow

Tel: (038374) 75211
Fax: (038374) 75223
eMail: al(at)humantouch(dot)de
http://www.humantouch.de

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel ?erud 2001-04-01 15:59:46 Dissapearing indexes, what's that all about?
Previous Message Peter Eisentraut 2001-04-01 14:53:23 Re: 7.0.X-> 7.1 dump/restore required?