Re: Trying to change the owner of some tables

On Wed, Jun 24, 2015 at 10:44 PM, John Scalia <jayknowsunix(at)gmail(dot)com>
wrote:

> Hi all,
>
> I'm trying to build a new server from a copy of one of our live Dbs, and I
> imported the schema from there and am now trying to get this new server
> setup with the right ownership
> and permissions. All the tables are/were owned by user A, and I've changed
> most of them to user B (names changed to protect the innocent, etc.,)
> However, some tables from the
> pg_dump I used to grab the schema, do not show up using \d nor can I see
> them in pg_class. I only found them when I tried to drop user A and psql
> complained. They appear to be in a
> different schema and I could change them one at a time, but there are more
> than 2200 of these. For the tables I've already changed, I just performed
> an update on pg_class where
> relowner = numeric ID of user A to set that to the numeric ID of user B.
>
> Now, this is a 9.2 server on CentOS, but I've not seen this behavior
> anywhere before. Where else should I see these? The only success I've had
> is \d+ new_schema.* and that doesn't
> help me change them.
>

​Possibly this...

http://www.postgresql.org/docs/9.4/static/sql-reassign-owned.html
​
David J.