From: | "Sue Lane" <suel(at)dpn(dot)com> |
---|---|
To: | <pgsql-general(at)commandprompt(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Ora2pg.pl - some feedback |
Date: | 2001-08-10 21:22:17 |
Message-ID: | 009401c121e2$881222e0$6e02a8c0@dpn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yes, thanks! That helps!
----- Original Message -----
From: <pgsql-general(at)commandprompt(dot)com>
To: Susan Lane <suel(at)dpn(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Friday, August 10, 2001 1:09 PM
Subject: Re: [GENERAL] 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Allan Engelhardt | 2001-08-10 21:28:25 | Re: Date Format Inquiry |
Previous Message | Christopher Zach | 2001-08-10 21:09:48 | Using oids for fast read-only access? |