On 6/13/19 8:14 AM, John Mikel wrote:
* 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 ;
Try: SELECT '"this is test"'::regnamespace::oid; not working ; Same for table name. As example: select '"space table"'::regclass; regclass --------------- "space table" (1 row)
i have question how use join between information_schema.columns and pg_attribute ? thanks regards*
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
