Yes, I know that one.
What I want to do however is within a stored procedure make a call and
store all tables in a given schema in a list.
Is this something you can answer?
thanks
J.V.
On 9/29/2011 3:25 AM, Richard Huxton wrote:
On 29/09/11 02:33, J.V. wrote:
Is is possible within a stored procedure to read all the tables in a
schema into a list?
[snip]
I need to extract this meta-data for a project.
Apart from information_schema mentioned elsewhere, start psql with -E
and then try \dt and similar - it will show you the queries it uses.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
