From: Graeme Merrall <gbmerrall@aol.com>
To: chriskl@familyhealth.com.au
To: Jiaqing <jjw72@swbell.net>
To: pgsql-sql@postgresql.org
Subject: Re: how to refer to tables in another database( or schema as oracle refers to)
Date: Tue, 20 Aug 2002 12:47:29 +1000
Message-ID: <MMEKJDBHGFPPMNBALCOHMEAMCDAA.GBMerrall@aol.com> (raw)
In-Reply-To: <GNELIHDDFBOCMGBFGEFOAEMFCDAA.chriskl@familyhealth.com.au>
> Basically - you can't. There is a program in the contrib/dblink directory
> that can help you though.
>
My take on this dblink program is to create SQL as a view.
For example coming from Oracle you might do "SELECT one, two, FROM foo.bar".
Convert that to a VIEW called simply "bar" or "foo_bar" that contains your
dblink query and there will be minimal chnages you'll have to make to your
actual code.
This could also be used to get around synonyms as well.
Cheers,
Graeme
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gbmerrall@aol.com, chriskl@familyhealth.com.au, jjw72@swbell.net
Subject: Re: how to refer to tables in another database( or schema as oracle refers to)
In-Reply-To: <MMEKJDBHGFPPMNBALCOHMEAMCDAA.GBMerrall@aol.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox