On 9/21/07, Paulo Nievierowski <[EMAIL PROTECTED]> wrote: > Como fazer um SQL que possa retornar os comentários de todas as colunas > de uma tabela?
De psql -E: SELECT a.attname, pg_catalog.format_type(a.atttypid, a.atttypmod), (SELECT substring(pg_catalog.pg_get_expr(d.adbin, d.adrelid) for 128) FROM pg_catalog.pg_attrdef d WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum AND a.atthasdef), a.attnotnull, a.attnum, pg_catalog.col_description(a.attrelid, a.attnum) FROM pg_catalog.pg_attribute a WHERE a.attrelid = '48789552' AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum -Leo -- Leonardo Cezar http://www.postgresql.org.br _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral