Re: stored procs - Mailing list pgsql-general

From Richard Huxton
Subject Re: stored procs
Date
Msg-id 4E843990.7040300@archonet.com
Whole thread Raw
In response to stored procs  ("J.V." <jvsrvcs@gmail.com>)
Responses Re: stored procs
List pgsql-general
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.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Jacqui Caren-home
Date:
Subject: Re: stored proc
Next
From: Richard Huxton
Date:
Subject: Re: Create Extension search path