Carla Mazzi escreveu:
Boa Tarde!Oi Carla, veja se este select te atende.... SELECT n.nspname, c.relname, a.attname, format_type(t.oid, null) AS typname FROM pg_namespace n, pg_class c, pg_attribute a, pg_type t WHERE n.oid = c.relnamespace AND c.relkind = 'r' -- sem índices AND n.nspname not like 'pg\\_%' -- sem catálogos AND n.nspname != 'information_schema' -- sem information_schema AND a.attnum > 0 -- sem atributo de sistema AND not a.attisdropped -- sem colunas removidas AND a.attrelid = c.oid AND a.atttypid = t.oid ORDER BY nspname, relname, attname
Marcelo.
|
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
