Report all Comments

paulo matadr wrote:

Hi all, i need make a report of all comments in the all tables.
Where postgres storage it?
Thanks

------------------------------------------------------------------------
Veja quais s�o os assuntos do momento no Yahoo! + Buscados: Top 10
<http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/&gt;
- Celebridades
<http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/celebridades/&gt;
- M�sica
<http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/m%C3%BAsica/&gt;
- Esportes
<http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/esportes/&gt;

Hoe this will help you

SELECT pn.nspname,pc.relname,ic.column_name,pd.description
FROM pg_catalog.pg_class pc,information_schema.columns ic ,
pg_catalog.pg_description pd,pg_catalog.pg_namespace pn
WHERE pc.oid=pd.objoid
AND pc.relname=ic.table_name
AND ic.ordinal_position=pd.objsubid
AND pc.relnamespace=pn.oid
AND pn.nspname in ('public')
ORDER BY pn.nspname,pc.relname,ic.ordinal_position;

With Regards
--Ashish Karalkar