Thank you very much Filip.
I am also thinking on the same direction but I think I was missing something
in syntax.
I am using Postgres Plus Standard server9.0.
For the database connection I have to give
dblink_exec('dbname=db2','update...');
My next concern is about performance as
There is no CREATE SYNONYM in PostgreSQL and it's not planned for
implementation.
There is also no direct support for foreign data wrapper. But it's planned
for 9.2.
Nearest that you can get with PostgreSQL 9.0 is cautious use of dblink and
views and rules.
here's a sample script to show what I
Hi,
In one of the migration porject want to access and update some tables from
other database on same postgresql server.
The question is how to access tables from other database on the same
postgres server.
If it is by database link like Oracle then what is the syntax.
And how to create synonym?
