Re: Add schema to the query

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Add schema to the query
Date: 2018-05-07 04:54:42
Message-ID: B612F05E-938C-443E-84EE-9F6A73B23352@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On May 6, 2018, at 8:19 PM, Igor Korot <ikorot01(at)gmail(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George Neuner 2018-05-07 05:22:42 Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN
Previous Message Igor Korot 2018-05-07 04:02:11 Re: Add schema to the query