| From: | "sheetal" <sheetal(at)anantinfotech(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Help... |
| Date: | 2002-06-05 20:06:36 |
| Message-ID: | 001801c20ccc$80b989e0$2264a8c0@sheetal |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Is there any table in postgres ,for eg pg_constraints, where in i can get the references for all the fields of a particular table in the data base?
Consider this..
I have
item master -- Item_code, Item Name
supplier master -- supplier_code, supplier_name
supplier_item_catalogue -- supplier_code references supplier master, item_code references item master
Now , if i select table supplier_item_catalogue for any reason from pg_tables, i should know that related tables item_master and supplier_master are also to be selected.
How can i do this using php /postgres?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | eric.jones | 2002-06-05 21:04:41 | Re: EASY!!! Timestamp conversion & php |
| Previous Message | Neil Conway | 2002-06-05 19:31:01 | Re: Insight into indexes? (or inverting then externally) |