Re: [GENERAL] List tables in reverse dependancy order

2007-08-08 Thread Pavel Stehule
Hello, five years ago I used CREATE OR REPLACE FUNCTION list_user_tables_sort_depend (owner VARCHAR, revers BOOLEAN) RETURNS SETOF VARCHAR AS ' DECLARE tabulky VARCHAR[]; i INTEGER; opakovat BOOLEAN = ''t''; pom VARCHAR; exportovano VARCHAR[] = ''{}''; r RECORD; mohu_exportovat BOOLEAN; BEGI

Re: [GENERAL] List tables in reverse dependancy order

2007-08-07 Thread Gregory Williamson
Lane [mailto:[EMAIL PROTECTED] Sent: Sat 8/4/2007 9:51 AM To: Gregory Williamson Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] List tables in reverse dependancy order "Gregory Williamson" <[EMAIL PROTECTED]> writes: > I'm trying to create a procedure that would l

Re: [GENERAL] List tables in reverse dependancy order

2007-08-04 Thread Tom Lane
"Gregory Williamson" <[EMAIL PROTECTED]> writes: > 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

[GENERAL] List tables in reverse dependancy order

2007-08-04 Thread Gregory Williamson
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