change owner of database -- answer

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.com
http://www.WhiteKnightHackers.com