Muito obrigado Matheus

 

 

On Tue, Aug 18, 2015 at 1:05 PM, Matheus Ferreira 
<[email protected]> wrote:

select

c.relname,

a.attname as "Column",

pg_catalog.format_type(a.atttypid, a.atttypmod) as "Datatype"


, a.attnotnull
 

 

from pg_catalog.pg_attribute a 

inner join pg_stat_user_tables c on a.attrelid = c.relid

WHERE

a.attnum > 0 AND

NOT a.attisdropped

order by c.relname, a.attname






At.

-- 

Matheus de Oliveira



_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a