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 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] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
