On 09/30/11 12:24 AM, J.V. wrote:
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.
so procedure1 calls procedure2 (not sure why this extra level of procedures, but I'm playing along)
and procedure2 does SELECT table_name from information_schema.tables where table_schema='someschemaname'; and returns this data as a 'list' (whatever you mean by that) ?
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
