From: | "Gregory Williamson" <Gregory(dot)Williamson(at)digitalglobe(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | List tables in reverse dependancy order |
Date: | 2007-08-01 23:11:46 |
Message-ID: | 8B319E5A30FF4A48BE7EEAAF609DB233011B0420@COMAIL01.digitalglobe.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am not sure if this is the appropriate list -- please point me at the correct one if not.
I'm trying to create a procedure that would let me retrieve a list of tables and views in a database that will be used to control the order in which lookup data is created/loaded. So, much simplified, if table references table B, which in turn references table A, we want output to list table A, B and C in that order.
I'm sure that this exists -- the pg_dump command must use some similar algorithm to decide in which order to load tables, but I can't see to puzzle this out.
Can anyone provide me with some clues, appropriate RTFM references, etc. ?
TIA,
Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company
Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
(My corporate masters made me say this.)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-08-02 00:22:41 | Re: why is the LIMIT clause slowing down this SELECT? |
Previous Message | Reid Thompson | 2007-08-01 22:26:40 | Re: Linux distro |