| From: | Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)PostgreSQL(dot)org |
| Subject: | Procedural language functions across servers |
| Date: | 2006-07-09 12:40:56 |
| Message-ID: | 44B0F958.99FCE00@telemetry.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I know that the FAQ says that the only way to implement a query across databases
is to use dblink, is this the only way available if additional procedural
languages are installed?
For example, assume I have a production server A that does not have PL/Perl
installed, and a hacker's server B (let's assume this is a separate machine)
complete with every possible bell and whistle. If I want to apply Perl (in a
read-only fashion) to extract data from the production tables is the "best" way
to have a PL/Perl function including references to dblink functions?
Similarly, if I have PostGIS or PL/R on the hacker's server, or- heaven forfend-
both, is the best way to get at the production server still to use dblink?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2006-07-09 13:34:40 | Re: [GENERAL] UUID's as primary keys |
| Previous Message | Martijn van Oosterhout | 2006-07-09 12:40:40 | Re: Getting Primary Key Value After Insert |