Postgres Pro
Downloads
Home   >   mailing lists

Add schema to the query - Mailing list pgsql-general

From Igor Korot
Subject Add schema to the query
Date
Msg-id CA+FnnTy2L=VTDutUTD+iXeRVjhP50OkJoj3uhK+5=8fDQngb1Q@mail.gmail.com
Whole thread Raw
Responses Re: Add schema to the query  (Melvin Davidson <melvin6925@gmail.com>)
Re: Add schema to the query  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: legrand legrand
Date:
Subject: Re: pg_stat_statements : how to catch non successfully finishedstatements ?
Next
From: Melvin Davidson
Date:
Subject: Re: Add schema to the query