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



Tue, 16 Jan 2001 12:59:03 +0100
"riccardo" <a.palmieri@fatainformatica.com>
View tables relationship
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


Tue, 16 Jan 2001 19:30:37 +0100
Gilles DAROLD <gilles@darold.net>
Re: View tables relationship