hi again
here is my query
select A.table_name as "table_name",A.domain_name as "domain",
format_type(c.atttypid, c.atttypmod) AS data_type ,A.column_name as "column_name",
A.is_nullable as "nullable",A.column_default as "default"
from information_schema.columns A inner join pg_attribute c on a.table_name::regclass::oid=c.attrelid
where a.table_schema in (select current_schema()) and a.column_name =c.attname ;
if i run this query in any database contain at least one table with space in their name , an error occurred
if i run this query in other database work fine
I tested this on pg 11.1 , pg 10.3, pg 9.6