Thread: owner of a table

owner of a table

From

Raphael Bauduin

Date:

30 January 2002, 09:16:47

Maybe a very stupid question (that's why I send it here :-) :
How can I see the owner of one/each table?

Thanks.

RAph

Re: owner of a table

From

Oliver Elphick

Date:

30 January 2002, 10:15:52

On Wed, 2002-01-30 at 10:50, Raphael Bauduin wrote:
> Maybe a very stupid question (that's why I send it here :-) :
> How can I see the owner of one/each table?

  SELECT c.relname, u.usename
    FROM pg_class AS c, pg_user AS u
    WHERE c.relname = 'your_table_name' AND u.usesysid = c.relowner;


--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "The Lord knoweth how to deliver the godly out of
      temptations, and to reserve the unjust unto the day of
      judgment to be punished;"            II Peter 2:9

Attachment

signature.asc