Jillian,
> How can I change ownership of a db to another user once it's been created?
The best way, really, is to pg_dump the database, drop it, and re-create it
under the new user.
You can change the owner by hacking the pg_database and pg_class tables.
However, this is fraught with potential fatal errors, so I'm not going to
attempt to describe it.
--
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco