Re: Add schema to the query

[Melvin Davidson <melvin6925@xxxxxxxxx>]

On Sun, May 6, 2018 at 10:33 PM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote:

On Sun, May 6, 2018 at 10:19 PM, Igor Korot <ikorot01@xxxxxxxxx> 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'

--

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