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
>
>
