On Mon, 19 Aug 2002, Stephan Szabo wrote:
> On Mon, 19 Aug 2002, Jiaqing wrote:
>
> > Hello,
> > I'm still new here and new to PostgreSQL, I'd like to know that after I
> > have created two databases on my site, such as one is called backend, and
> > another one is called admin, how do I refer(qu
On Mon, 19 Aug 2002, Jiaqing wrote:
> Hello,
> I'm still new here and new to PostgreSQL, I'd like to know that after I
> have created two databases on my site, such as one is called backend, and
> another one is called admin, how do I refer(query) the table from backend
> while I'm connected to a
> 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_ba
3 AM
> To: [EMAIL PROTECTED]
> Subject: [SQL] how to refer to tables in another database( or schema as
> oracle refers to)
>
>
> Hello,
> I'm still new here and new to PostgreSQL, I'd like to know that after I
> have created two databases on my site, such as one is called b
Hello,
I'm still new here and new to PostgreSQL, I'd like to know that after I
have created two databases on my site, such as one is called backend, and
another one is called admin, how do I refer(query) the table from backend
while I'm connected to admin database, or is it possible to do that
