Re: Report all Comments - Mailing list pgsql-general

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/>
> - Celebridades
> <http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/celebridades/>
> - Música
> <http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/m%C3%BAsica/>
> - Esportes
> <http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/esportes/>
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