On Wed, December 8, 2010 17:46, Guillaume Lelarge wrote:
>
> You should try REASSIGN OWNED BY. See
> http://www.postgresql.org/docs/9.0/interactive/sql-reassign-owned.html
Thanks for that. I ended up doing a pg_dump followed by a sed
followed by a psql < which sufficed for my purposes, even it it did
seem a bit convoluted. The REASSIGN OWNED BY seems the more
sensible approach.
--
*** 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