Add schema to the query

From: Igor Korot <ikorot01(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Add schema to the query
Date: 2018-05-07 02:19:20
Message-ID: CA+FnnTy2L=VTDutUTD+iXeRVjhP50OkJoj3uhK+5=8fDQngb1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2018-05-07 02:33:37 Re: Add schema to the query
Previous Message legrand legrand 2018-05-06 22:46:10 Re: pg_stat_statements : how to catch non successfully finished statements ?