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
-
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
