Extracting database metadata

Extracting database metadata

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  ICQ #91619595, tel.(502)261417
----------------------------------------------------------------