By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,302 Members | 1,185 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,302 IT Pros & Developers. It's quick & easy.

create template database

P: n/a
I'm trying to create a template database as a superuser. I set the
value in pg_database datistemplate to 't'. But when I create a
database as another user i don't have any priviliges on the tables in
the new database. So I granted ALL to PUBLIC on the tables in the
template database. Now when I create a database with the new template
I can use it, but the tables are still owned by the user that created
(owns) the template.

Is there anything i need to do to make the template a true template, I
mean, that it behaves in the same way as template1?

GreetZ, Sam

ps: A happy new year to you all!
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.