Re: [HACKERS] View tables relationship

2001-01-16 Thread Gilles DAROLD
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

[HACKERS] View tables relationship

2001-01-16 Thread riccardo
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 muc