Search Postgresql Archives

stored procs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Is is possible within a stored procedure to read all the tables in a schema into a list?

From that list and for each table is it possible to find the foreign keys in that table?

From that list of foreign keys, is it possible to find out which field in which table the FK corresponds to?

I need to extract this meta-data for a project.

Regards,


J.V.

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux