Re: View tables relationship - Mailing list pgsql-hackers

From Gilles DAROLD
Subject Re: View tables relationship
Date
Msg-id 3A64934D.465E6A63@darold.net
Whole thread Raw
In response to View tables relationship  ("riccardo" <a.palmieri@fatainformatica.com>)
List 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 by date:

Previous
From: bruc@stone.congenomics.com (Robert E. Bruccoleri)
Date:
Subject: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3
Next
From: The Hermit Hacker
Date:
Subject: CASE inet << inet ...