This was posted several times as a question, here is the answer that I used:
use createdb from whereever...
\d pg_database
Table = pg_database
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| datname | name | 32 |
| datdba | int4 | 4 |
| encoding | int4 | 4 |
| datpath | text | var |
+----------------------------------+----------------------------------+-------+
=> select * from pg_database;
datname |datdba|encoding|datpath
-----------+------+--------+-----------
template1 | 124| 0|template1
mydatabase | 124| 0|mydatabase
I then sent
UPDATE pg_database SET datdba=99 WHERE datname=mydatabase;
And it updated the owner of the DB.
This area needs documentation!
--
Zot O'Connor
http://www.ZotConsulting.comhttp://www.WhiteKnightHackers.com
