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. > >> > >> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
