| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | Devrim GUNDUZ <devrim(at)gunduz(dot)org> |
| Cc: | Jodi Kanter <jkanter(at)virginia(dot)edu>, Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: cross databases? |
| Date: | 2004-07-08 16:00:49 |
| Message-ID: | 1089302449.29038.10.camel@braydb |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 2004-07-08 at 16:34, Devrim GUNDUZ wrote:
> On Thu, 8 Jul 2004, Jodi Kanter wrote:
>
> > I am working with someone who uses MySQL and says that he has two
> > separate databases in which he can query across. I am curious if that is
> > something that can be done in postgres?
>
> Yes, it's possible with PostgreSQL.
>
> See contrib/dblink.
But a more convenient alternative is to use schemas, which MySQL does
not (I think) support.
Oliver Elphick
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hemapriya | 2004-07-08 16:07:30 | Connect to postgres from a script using password |
| Previous Message | Mike Rylander | 2004-07-08 15:55:31 | Re: cross databases? |