Re: stored procs

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.
>