Re: 'Following' the Primary key

Turbo Fredriksson wrote:
>>>>>>"Oliver" == Oliver Elphick <olly@lfix.co.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?
> 

See:
http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=36

for one possible way.

Joe