Re: Add schema to the query

Rob, On Sun, May 6, 2018 at 11:54 PM, Rob Sargent wrote: > > >> On May 6, 2018, at 8:19 PM, Igor Korot 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 = ? >>

Re: Add schema to the query

> On May 6, 2018, at 8:19 PM, Igor Korot 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 sche

Re: Add schema to the query

Hi, Melvin, On Sun, May 6, 2018 at 9:37 PM, Melvin Davidson wrote: > > > On Sun, May 6, 2018 at 10:33 PM, Melvin Davidson > wrote: >> >> >> >> On Sun, May 6, 2018 at 10:19 PM, Igor Korot wrote: >>> >>> Hi, ALL, >>> >>> Is there an easy way to add the schema to the following query: >>> >>> SELEC

Re: Add schema to the query

On Sun, May 6, 2018 at 10:33 PM, Melvin Davidson wrote: > > > On Sun, May 6, 2018 at 10:19 PM, Igor Korot 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 = ? >

Re: Add schema to the query

On Sun, May 6, 2018 at 10:19 PM, Igor Korot 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 follow