Re: stored procs

From: Richard Huxton <dev(at)archonet(dot)com>
To: "J(dot)V(dot)" <jvsrvcs(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: stored procs
Date: 2011-09-29 09:25:36
Message-ID: 4E843990.7040300@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2011-09-29 09:35:18 Re: Create Extension search path
Previous Message Jacqui Caren-home 2011-09-29 08:21:06 Re: stored proc