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
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
"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
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