From: | Turbo Fredriksson <turbo(at)bayour(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: 'Following' the Primary key |
Date: | 2002-03-14 13:28:37 |
Message-ID: | 874rjji8hm.fsf@papadoc.bayour.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>>>>> "Oliver" == Oliver Elphick <olly(at)lfix(dot)co(dot)uk> writes:
Oliver> On Thu, 2002-03-14 at 13:00, Turbo Fredriksson wrote:
>> With '\d table' I get the columns, types and modifiers. Also
>> the Primary key, Indexes etc are shown.
>>
>> But if I want to know WHAT the primary key 'is pointing to',
>> how would I do that (ie, what is the primary key)?
Oliver> Just do \d again on the key index name:
Oliver> bray=# \d org_contact
Oliver> bray=# \d org_contact_pkey
Cool. Works fine in 7.2, but not 7.1.3 (which we're running on our
production systems)...
Any idea how to do this on 7.1.3?
--
jihad iodine subway arrangements 767 Cocaine 747 Waco, Texas [Hello to
all my fans in domestic surveillance] terrorist security radar North
Korea plutonium Semtex
[See http://www.aclu.org/echelonwatch/index.html for more about this]
From | Date | Subject | |
---|---|---|---|
Next Message | Vince Vielhaber | 2002-03-14 13:29:27 | Re: insert statements |
Previous Message | Oliver Elphick | 2002-03-14 13:19:19 | Re: 'Following' the Primary key |