Rob,
On Sun, May 6, 2018 at 11:54 PM, Rob Sargent <robjsargent@gmail.com> wrote:
>
>
>> On May 6, 2018, at 8:19 PM, Igor Korot <ikorot01@gmail.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.
