Rob, On Sun, May 6, 2018 at 11:54 PM, Rob Sargent <robjsarg...@gmail.com> wrote: > > >> On May 6, 2018, at 8:19 PM, Igor Korot <ikoro...@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?
Yes, I am. That;s what I ended up with: SELECT u.usename FROM pg_class c, pg_user u, pg_namespace n WHERE n.oid = c.relnamespace AND u.usesysid = c.relowner AND n.nspname = ? AND relname = ? Thank you.
