Re: Add schema to the query - Mailing list pgsql-general

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!