Re: Add schema to the query

Rob,

On Sun, May 6, 2018 at 11:54 PM, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
>
>> On May 6, 2018, at 8: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.
>>
> Are you looking for the owner of a particular schema.tablename?

Yes, I am.

That;s what I ended up with:

SELECT u.usename FROM pg_class c, pg_user u, pg_namespace n WHERE
n.oid = c.relnamespace AND u.usesysid = c.relowner AND n.nspname = ?
AND relname = ?

Thank you.