From: | "Alexander Staubo" <alex(at)purefiction(dot)net> |
---|---|
To: | fasupport(at)allcoast(dot)net |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Possible new feature |
Date: | 2007-07-30 12:30:28 |
Message-ID: | 88daf38c0707300530q7ff14c0dx9f2bd18b153cccfb@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 7/30/07, mgould <mgould(at)allcoast(dot)net> wrote:
> I'm in the process of moving to PostGres from iAnywhere's SQL Anywhere v 10.
> One of the neat features from ASA 10 is the ability to create "proxy
> tables" These tables can be local or remote.
Check out the dblink contrib module that comes with PostgreSQL. It
does the exact same thing, though without special syntax:
create view foo as
select * from dblink(
'host=1.2.3.4 dbname=remotedb user=dbuser password=secretpass',
'select id, title from foo')
as remote_foo(id int, title text);
Alexander.
From | Date | Subject | |
---|---|---|---|
Next Message | Henrik Zagerholm | 2007-07-30 12:57:41 | Re: Slow query but can't see whats wrong |
Previous Message | Lewis Cunningham | 2007-07-30 12:22:38 | Re: [SQL] Tunning PostgreSQL performance for views on Windows |