>>>>> "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 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] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly