Re: Ora2pg.pl - some feedback

On Fri, 10 Aug 2001 pgsql-general(at)commandprompt(dot)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(at)commandprompt(dot)com by way of pgsql-general(at)commandprompt(dot)com