Re: 'Following' the Primary key

Поиск
Список
Период
Сортировка
От Turbo Fredriksson
Тема Re: 'Following' the Primary key
Дата
Msg-id 874rjji8hm.fsf@papadoc.bayour.com
обсуждение исходный текст
Ответ на Re: 'Following' the Primary key  (Oliver Elphick <olly@lfix.co.uk>)
Ответы Re: 'Following' the Primary key  (Jean-Paul ARGUDO <jean-paul.argudo@idealx.com>)
Список pgsql-hackers
>>>>> "Oliver" == Oliver Elphick <olly@lfix.co.uk> 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
pointingto',   >> 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]


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: 'Following' the Primary key
Следующее
От: Vince Vielhaber
Дата:
Сообщение: Re: insert statements