Thread: Extracting database metadata

Extracting database metadata

From
Grzegorz Mucha
Date:
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
----------------------------------------------------------------