hi ,
i am here to tell you that this test in query is not working when the
table name in the database or schema name contain space
a.table_name::regclass=b.attrelid
a is information_schema.columns
b is pg_attribute
trying this in two different databases the first database contain table
with space in his name (Problem when running query)
the second no ( work fine)
the same problme if you get Oid from schema name.
SELECT 'public'::regnamespace::oid; work ;
create schema " this is test" ;
SELECT 'this is test'::regnamespace::oid; not working ;
i have question how use join between information_schema.columns and
pg_attribute ? thanks
regards
i am here to tell you that this test in query is not working when the
table name in the database or schema name contain space
a.table_name::regclass=b.attrelid
a is information_schema.columns
b is pg_attribute
trying this in two different databases the first database contain table
with space in his name (Problem when running query)
the second no ( work fine)
the same problme if you get Oid from schema name.
SELECT 'public'::regnamespace::oid; work ;
create schema " this is test" ;
SELECT 'this is test'::regnamespace::oid; not working ;
i have question how use join between information_schema.columns and
pg_attribute ? thanks
regards