Re: 'Following' the Primary key

Quoting Oliver Elphick <olly(at)lfix(dot)co(dot)uk>:

> 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 we're running on our
> > production systems)...
> >
> > Any idea how to do this on 7.1.3?
>
> psql -E tells me that the queries include this:

I thought it was '-e', and that didn't give any output,
so I never figured out this my self...

> SELECT a.attname, format_type(a.atttypid, a.atttypmod),
> a.attnotnull, a.atthasdef, a.attnum
> FROM pg_class c, pg_attribute a
> WHERE c.relname = 'org_contact_pkey'
> AND a.attnum > 0 AND a.attrelid = c.oid
> ORDER BY a.attnum;

Works like a charm, thanx!!
--
$400 million in gold bullion Soviet Saddam Hussein supercomputer Waco,
Texas Iran munitions PLO explosion Cuba congress Semtex BATF Treasury
NSA
[See http://www.aclu.org/echelonwatch/index.html for more about this]