Ola Jota, Isso mesmo. Muito obrigado.
2009/11/17 JotaComm <[email protected]>: > > 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 > > _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
