Karl O. Pinc wrote:
4. Can I query an object in another database, like in Oracle's dblink?
I'm no expert. I don't believe so. You can query across scheams
in the same database but not across databases. You could do
something (anything!) by writing an external function in C or
whatever, but I couldn't say how much work that would take.
Karl <kop@xxxxxxxx>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
Look in /contrib directory for dblink. That will enable you to query other pg databases.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)