Paweł Domański
21 lines
764 B
SQL
21 lines
764 B
SQL
SELECT c.table_schema as schema,
|
|
c.table_name as table,
|
|
c.column_name as column,
|
|
c.data_type as type,
|
|
case when c.data_type LIKE '%char%'
|
|
then COALESCE(character_maximum_length::text, 'N/A')
|
|
when c.data_type LIKE '%numeric%'
|
|
then '(' || c.numeric_precision::text || ', ' || c.numeric_scale::text || ')'
|
|
when c.data_type LIKE '%int%'
|
|
then c.numeric_precision::text
|
|
else COALESCE(character_maximum_length::text, 'N/A')
|
|
end as size
|
|
FROM information_schema.columns c
|
|
WHERE c.table_schema NOT LIKE 'pg_%'
|
|
AND c.table_schema NOT LIKE 'information%'
|
|
AND c.table_name NOT LIKE 'sql_%'
|
|
AND c.is_updatable = 'YES'
|
|
AND c.column_name LIKE '%<COLUMN_NAME>%'
|
|
ORDER BY c.table_name, c.column_name;
|
|
|