Turbo Fredriksson wrote:
>>"Oliver" == Oliver Elphick <[EMAIL PROTECTED]> 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.
> >>
>
Quoting Oliver Elphick <[EMAIL PROTECTED]>:
> On Thu, 2002-03-14 at 13:28, Turbo Fredriksson wrote:
> > 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
> 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?
contact=# \d t_operation
Table "t_operation"
Attribute | Type | Modifier
> "Oliver" == Oliver Elphick <[EMAIL PROTECTED]> 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 k
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)?
Just do \d again on
