cfirmo33 · November 24, 2017 18:22
diff --git a/Lista das colunas de uma tabela b/Lista das colunas de uma tabela
 select
 c.relname as tableName,
 a.attname as "Column",
 pg_catalog.format_type(a.atttypid, a.atttypmod) as "Datatype"
 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
 AND c.relname like '@TABLE_NAME'
 AND a.attname like '%COLUNM_DESC%'
 order by c.relname, a.attname
	select
	c.relname as tableName,
	a.attname as "Column",
	pg_catalog.format_type(a.atttypid, a.atttypmod) as "Datatype"
	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
	AND c.relname like '@TABLE_NAME'
	AND a.attname like '%COLUNM_DESC%'
	order by c.relname, a.attname