On Fri, 10 Aug 2001 pgsql-general@commandprompt.com wrote:
>For example:
>
>lx=# SELECT datname, datdba FROM pg_database
>lx-# INNER JOIN pg_user ON (datdba=usesysid);
> datname | datdba
> -------------+--------
> postgres | 507
> twig2 | 501
> template0 | 507
Whoops, that was missing an important identifier to be meaningful. ;)
Trying again:
lx=# SELECT datname, datdba, usename FROM pg_database
lx-# INNER JOIN pg_user ON (datdba=usesysid);
datname | datdba | usename
--------------+--------+----------
postgres | 507 | postgres
twig2 | 501 | jd
template0 | 507 | postgres
...
So, look up the usename/usesysid in the pg_user table to find out what new
datdba to UPDATE your database (datname) to in pg_database. Hope that's
helpful.
Regards,
Jw.
--
jlx@commandprompt.com by way of pgsql-general@commandprompt.com