Re: Add schema to the query

Hi, Melvin,

On Sun, May 6, 2018 at 9:37 PM, Melvin Davidson <melvin6925(at)gmail(dot)com> wrote:
>
>
> 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'

Sorry needed to filter on the schema + table.

So, thank you.

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