Re: Ora2pg.pl - some feedback

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