How to easily spot Foreign keys

Поиск
Список
Период
Сортировка
От Harry Broomhall
Тема How to easily spot Foreign keys
Дата
Msg-id 200308131535.QAA17484@haeb.noc.uk.easynet.net
обсуждение исходный текст
Ответы Re: How to easily spot Foreign keys  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: How to easily spot Foreign keys  (Nabil Sayegh <postgresql@e-trolley.de>)
Список pgsql-novice
    I am currently doing a bit of 'reverse engineering' and documenting
a set of tables.

    Using pgsql and the \d command produces info about most things, but
doesn't *obviously* produce foreign key or references info.

    I am aware that the info is buried somewhere in the 'ContraintTrigger'
items, but it isn't obvious how to retrieve the info.

    Is there a tool, or a work-around to get this info in a rather more
'user-friendly' fashion?

    Regards,
        Harry.


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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: pqgetresultset problem
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: How to easily spot Foreign keys