Postgres Pro
Downloads
Home   >   mailing lists

Re: how to refer to tables in another database( or schema as oracle refers to) - Mailing list pgsql-sql

From Graeme Merrall
Subject Re: how to refer to tables in another database( or schema as oracle refers to)
Date
Msg-id MMEKJDBHGFPPMNBALCOHMEAMCDAA.GBMerrall@aol.com
Whole thread Raw
In response to Re: how to refer to tables in another database( or schema as oracle refers to)  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-sql
Tree view 
> 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

pgsql-sql by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Modify column type
Next
From: Stephan Szabo
Date:
Subject: Re: how to refer to tables in another database( or schema as