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