stored procs

From: "J(dot)V(dot)" <jvsrvcs(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: stored procs
Date: 2011-09-29 01:33:53
Message-ID: 4E83CB01.1030501@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J.V. 2011-09-29 01:34:03 stored proc
Previous Message Ondrej Ivanič 2011-09-28 22:46:36 Re: Rules going away