Thread: Add schema to the 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.
On Sun, May 6, 2018 at 10:19 PM, Igor Korot <ikorot01@gmail.com> 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!
On Sun, May 6, 2018 at 10:33 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
On Sun, May 6, 2018 at 10:19 PM, Igor Korot <ikorot01@gmail.com> 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 = ?
--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'
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!
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
Hi, Melvin, On Sun, May 6, 2018 at 9:37 PM, Melvin Davidson <melvin6925@gmail.com> wrote: > > > On Sun, May 6, 2018 at 10:33 PM, Melvin Davidson <melvin6925@gmail.com> > wrote: >> >> >> >> On Sun, May 6, 2018 at 10: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. >>> >> >> >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!
> 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?
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.