Setting owner for all tables - Mailing list pgsql-novice

From Chris McKinney
Subject Setting owner for all tables
Date
Msg-id b1a37fb20902100618w3379fb37p967c696ba500c354@mail.gmail.com
Whole thread Raw
Responses Re: Setting owner for all tables  (Serge Fonville <serge.fonville@gmail.com>)
List pgsql-novice
Hello all,

I'm using a template database as the base for new database creation.  The user executing this command is a superuser.  Here's the SQL statement that I'm using for creating new databases:

CREATE DATABASE mynewdatabase OWNER someuser TEMPLATE mytemplatedb ENCODING 'UTF8'.

I noticed that all the tables still seem to be owned by the user that created the template database initially which isn't what I expected.    Is there a step that I'm missing that will allow me to have all the tables / functions / etc ownership changed also?   I'm running postgresql-8.1.

Thanks!


pgsql-novice by date:

Previous
From: Carol Walter
Date:
Subject: Re: Cluster / Tablespace ?
Next
From: Serge Fonville
Date:
Subject: Re: Setting owner for all tables