Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] RE: [GENERAL] PostgreSQL counterpart to DBMS_METADATA?‏ - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: [GENERAL] RE: [GENERAL] PostgreSQL counterpart to DBMS_METADATA?‏
Date
Msg-id 4F158A54.1000509@iol.ie
Whole thread Raw
In response to RE: [GENERAL] PostgreSQL counterpart to DBMS_METADATA?‏  ("Tefft, Michael J" <Michael.J.Tefft@snapon.com>)
List pgsql-general
Tree view 
On 17/01/2012 12:58, Tefft, Michael J wrote:
> Any suggestions for doing this from PL/pgSQL?

If you run psql with the -E option, and then do various \d commands to
examine database objects, it will output the queries it generates to get
metadata - you can then adapt these to your own needs.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: "P. Broennimann"
Date:
Subject: Basic PostgreSQL Question
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL counterpart to DBMS_METADATA?