List tables in reverse dependancy order

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.)

Responses

Browse pgsql-general by date

  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