Re: [GENERAL] One SQL to access two databases.

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr>, hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] One SQL to access two databases.
Date: 2002-12-02 11:05:25
Message-ID: 20021202110525.GA2340@zf.jcu.cz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Dalitz 2002-12-02 11:21:27 Re: USAGE on schema allowed by default?
Previous Message Lee Kindness 2002-12-02 10:54:10 7.4 Wishlist

Browse pgsql-hackers by date

  From Date Subject
Next Message Christoph Dalitz 2002-12-02 11:21:27 Re: USAGE on schema allowed by default?
Previous Message Lee Kindness 2002-12-02 10:54:10 7.4 Wishlist