On Sun, May 6, 2018 at 10:19 PM, Igor Korot <ikorot01@xxxxxxxxx> wrote:
>Is there an easy way to add the schema to the following query:
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.
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 = ?
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!
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
