Thread: View tables relationship

View tables relationship

From
"riccardo"
Date:
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




Re: View tables relationship

From
Gilles DAROLD
Date:
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