Extracting database metadata - Mailing list pgsql-general

From Grzegorz Mucha
Subject Extracting database metadata
Date
Msg-id 01061312012500.02593@theta
Whole thread Raw
List pgsql-general
Is there somewhere a solution that would list PG metadata? Most things are
simple to do, though foreign key information is not that trivial.
Regarding FKeys(as they interest me the most), I only noticed that they
can be extracted from pg_trigger, though the form the data are written
makes it difficult to do something with it in SQL or PLpgSQL (at least for
me).
I'd appreciate if someone shared his solution with me (perhaps a query or
a stored procedure that would extract FK data in tabular form - with table
and column names as columns)

--
Grzegorz Mucha <mucher@tigana.pl> ICQ #91619595, tel.(502)261417
----------------------------------------------------------------

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Re: Does PostgreSQL support EXISTS?
Next
From: "Andy Samuel"
Date:
Subject: Vacuum-ing without disconnecting users