Re: bug regclass::oid

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(dot)klaver(at)aklaver(dot)com