I am testing a Rails deployment and wish to copy a database
assigning it an new owner. I have tried this:
createdb --owner=hll_theheart_db_devl
--template=hll_th_deploytest_prod hll_theheart_devl
While this indeed sets the database owner to hll_theheart_db_devl
everything else, schema, tables whatever, remains owned by the
original owner. Is there no way to change the owner everywhere in
the cloned database using cretedb? Or am I constrained to do a dump
all and restore?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3