Re: List tables in load order

Thanks for the tip -- I'll check into it.

Sorry for top-posting but my email reader is challenged.

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

-----Original Message-----
From: Kristo Kaiv [mailto:kristo(dot)kaiv(at)skype(dot)net]
Sent: Tue 8/7/2007 3:58 PM
To: Gregory Williamson
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] List tables in load order

On 02.08.2007, at 4:16, Gregory Williamson wrote:

> 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.
>
This is currently one of the main topics in skytools list. Check the
archives:
http://pgfoundry.org/pipermail/skytools-users/2007-July/000074.html
http://pgfoundry.org/pipermail/skytools-users/2007-August/thread.html
AFAIK they don't have it quite ready yet but shouldn't take long...

Kristo Kaiv
http://kaiv.wordpress.com (PostgreSQL blog)