Re: View tables relationship

Поиск
Список
Период
Сортировка
От Gilles DAROLD
Тема Re: View tables relationship
Дата
Msg-id 3A64934D.465E6A63@darold.net
обсуждение исходный текст
Ответ на View tables relationship  ("riccardo" <a.palmieri@fatainformatica.com>)
Список pgsql-hackers
Hi,

This question have been posted recently, please take a look to archive.

I use this very simple query :
   SELECT a.tgargs   FROM pg_class c, pg_trigger a   WHERE a.tgname LIKE 'RI_ConstraintTrigger_%' AND
c.relname='$table'AND
 
a.tgrelid = c.oid

Regards,

Gilles DAROLD

riccardo wrote:

> Hi.
> I have a big problem with postgres because I need to know how I can see the
> relations among the table like foreign-key.
> It' s possible use some commands or graphic tool from wich I can see that
> relations?
> Do you know some sites where i can found more information about this!
>
> Thank you very much,
> and exuse me for my bad English!
>
> Fabio



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

Предыдущее
От: bruc@stone.congenomics.com (Robert E. Bruccoleri)
Дата:
Сообщение: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3
Следующее
От: The Hermit Hacker
Дата:
Сообщение: CASE inet << inet ...