List tables in load order

From: "Gregory Williamson" <Gregory(dot)Williamson(at)digitalglobe(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: List tables in load order
Date: 2007-08-02 01:16:59
Message-ID: 8B319E5A30FF4A48BE7EEAAF609DB233011B0428@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. ?

Apologies for any duplicate postings -- had issues with my sign up.

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 Ron Johnson 2007-08-02 02:33:28 Re: Linux distro
Previous Message Stephan Szabo 2007-08-02 01:07:27 Re: why is the LIMIT clause slowing down this SELECT?