Manage postgresql template

gistfile1.txt

# our template database will be called template2
# as user foobar
$ createdb template2
$ psql -d template2 -c 'create table test (id integer)'
$ psql -d template2 -c '\d' # you see that the table is owned by foobar
# create a new db based on the template
$ createdb new -T template2 -O newuser
$ psql -d new -c 'REASSIGN OWNED BY foobar TO newuser'
$ psql -d new -c '\d' # the table test is owned by newuser
$ psql -l # show that the owner of template2 is now newuser