Re: Ora2pg.pl - some feedback

Yes, thanks!  That helps!

----- Original Message -----
From: <pgsql-general@commandprompt.com>
To: Susan Lane <suel@dpn.com>
Cc: <pgsql-general@postgresql.org>
Sent: Friday, August 10, 2001 1:09 PM
Subject: Re: [GENERAL] 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
>
>