On Wed, Mar 24, 2004 at 03:09:21PM -0500, Louie Kwan wrote: > Hi All, > > Due to some security issues, we need to separate the data for one customer > into a separate PostgreSQL box/server. > > My question is that how could we have sql statements which allow us to > access multiple PostgreSQL databases at the same time. Not separate schema, > but in different postgresql server.
Doesn't seem like much security if you're going to break it by putting a back door in. But there's a contrib module called dblink that will likely help you. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])