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

From Rob Sargent
Subject Re: Add schema to the query
Date
Msg-id B612F05E-938C-443E-84EE-9F6A73B23352@gmail.com
Whole thread Raw
In response to Add schema to the query  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Add schema to the query  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general

> 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?


pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Add schema to the query
Next
From: George Neuner
Date:
Subject: Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN