Re: Add schema to the query

On Sun, May 6, 2018 at 10:33 PM, Melvin Davidson <melvin6925(at)gmail(dot)com>
wrote:

>
>
> On Sun, May 6, 2018 at 10:19 PM, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>
>> Hi, ALL,
>>
>> Is there an easy way to add the schema to the following query:
>>
>> SELECT u.usename FROM pg_class c, pg_user u WHERE u.usesysid =
>> c.relowner AND relname = ?
>>
>> Thank you.
>>
>>
> >Is there an easy way to add the schema to the following query:
>
> You mean like this?
> SELECT u.usename,
> *n.nspname AS schema*
> FROM pg_class c
> *JOIN pg_namespace n ON n.oid = c.relnamespace,*
> pg_user u
> WHERE u.usesysid = c.relowner
> AND relname = ?
>
>
> --
> *Melvin Davidson*
> *Maj. Database & Exploration Specialist*
> *Universe Exploration Command – UXC*
> Employment by invitation only!
>

OR do you mean like this?
SELECT u.usename
FROM pg_class c
*JOIN pg_namespace n ON n.oid = c.relnamespace, *
pg_user u
WHERE u.usesysid = c.relowner
AND relname = ?

* AND n.nspname = 'public'*

--
*Melvin Davidson*
*Maj. Database & Exploration Specialist*
*Universe Exploration Command – UXC*
Employment by invitation only!