Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] One SQL to access two databases. - Mailing list pgsql-hackers

From Karel Zak
Subject Re: [GENERAL] One SQL to access two databases.
Date
Msg-id 20021202110525.GA2340@zf.jcu.cz
Whole thread Raw
In response to Re: [GENERAL] One SQL to access two databases.  (Joe Conway <mail@joeconway.com>)
Responses Re: [GENERAL] One SQL to access two databases.
Re: [GENERAL] One SQL to access two databases.
List pgsql-hackers
Tree view 
On Sat, Nov 30, 2002 at 01:11:20PM -0800, Joe Conway wrote:
> As I said, this is all very preliminary; comments, suggestions, requests 
> are all welcome.
Only idea/dream: what implement dblink as "virtual" schema.
CREATE SCHEMA myschema AS DBLINK TO ... some connection options ...;
SELECT * FROM myschema.tabname;
This solution allows use dblink as really transparent.
   Karel

-- Karel Zak  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/

pgsql-hackers by date:

Previous
From: Lee Kindness
Date:
Subject: 7.4 Wishlist
Next
From: Karel Zak
Date:
Subject: Re: 7.4 Wishlist