* 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*
