Setting owner for all tables

Поиск
Список
Период
Сортировка
От Chris McKinney
Тема Setting owner for all tables
Дата
Msg-id b1a37fb20902100618w3379fb37p967c696ba500c354@mail.gmail.com
обсуждение исходный текст
Ответы Re: Setting owner for all tables  (Serge Fonville <serge.fonville@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Carol Walter
Дата:
Сообщение: Re: Cluster / Tablespace ?
Следующее
От: Serge Fonville
Дата:
Сообщение: Re: Setting owner for all tables