Olá, Jorge
2009/11/17 jorge sanfelice <[email protected]>
> Prezados,
>
> Eu uso o seguinte sql para identificar as colunas do meu banco sem
> comentarios:
> SELECT
> 'COMMENT ON COLUMN '||c.relname||'.'||a.attname ||' IS \'.\';' as
> COMENTARIOS
> 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 = 'public' -- COM ESPECIFICACAO DO schema
> AND a.attnum > 0 -- sem atributo de sistema
> AND not a.attisdropped -- sem colunas removidas
> AND c.relname ILIKE 'ressarcimento%'
> and ( select coalesce(d.description,'') as desc from pg_description d
> where d.objoid=a.attrelid and d.objsubid=a.attnum) is null
> AND a.attrelid = c.oid AND a.atttypid = t.oid ORDER BY nspname,
> relname, attname;
>
> Alguem poderia me ajudar a fazer um sql para identificar as tabelas
> que estao sem comentarios? (obs: no caso me refiro sem o "comment
> table")
>
Veja se é isso que você precisa:
SELECT pg_class.relname FROM pg_namespace JOIN pg_class ON
pg_namespace.oid=pg_class.relnamespace WHERE pg_namespace.nspname IN
('public') AND pg_class.relkind='r' AND pg_class.oid NOT IN (SELECT objoid
FROM pg_description);
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
[]s
--
JotaComm
http://jotacomm.wordpress.com
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
