Search Postgresql Archives

bug regclass::oid

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux