Re: 'Following' the Primary key

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]

In response to

Responses

Browse pgsql-hackers by date

  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