Skip site navigation (1) Skip section navigation (2)

Re: External Database Connection

From: Joe Conway <joseph(dot)conway(at)home(dot)com>
To: "Sean K(dot) Sell" <sean(at)nist(dot)gov>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: External Database Connection
Date: 2001-10-30 05:38:44
Message-ID: 3BDE3CE4.70103@home.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Sean K. Sell wrote:

> Has anyone successfully hacked an external database table as a view.
> 
> I was thinking that this may be possible using a C function and the Rules architecture but I don't have much experience with PostgreSQL so I thought I
> would check with the list to see what if anything others had attempted.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
> 

Sort of (it's ugly, but works for simple needs) . . . see dblink under 
contrib in the 7.2 beta. Be sure to read the README.

-- Joe



In response to

pgsql-hackers by date

Next:From: Hiroshi InoueDate: 2001-10-30 05:46:50
Subject: Re: pgsql-committers?
Previous:From: Tom LaneDate: 2001-10-30 05:18:11
Subject: Re: pgsql-committers?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group