On 09/28/11 6:33 PM, J.V. wrote:
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.
that metadata should all be available in the information_schema.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
