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:
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.