Re: [GENERAL] RE: [GENERAL] PostgreSQL counterpart to DBMS_METADATA?‏

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: "Tefft, Michael J" <Michael(dot)J(dot)Tefft(at)snapon(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] RE: [GENERAL] PostgreSQL counterpart to DBMS_METADATA?‏
Date: 2012-01-17 14:48:52
Message-ID: 4F158A54.1000509@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-01-17 15:03:23 Re: PostgreSQL counterpart to DBMS_METADATA?
Previous Message shitake 2012-01-17 14:22:04 Re: Upgrade Postgres 8.4SS >> 9.1