Merlin Moncure wrote:
On Jan 4, 2008 11:51 AM, Afewtips.com <afewtips@xxxxxxxxx> wrote:
I do read mentions about dblink connections, but how to install it
looks unclear and complicated.
small clarification here. dblink is for connecting two postgresql
databases together. It is, IMO, neither unclear nor complicated :-).
dbilink, (note the 'I'), which aiui uses perl dbi in a dblink style
interface...never used it personally.
for moving data in and out of sql server and postgresql, you have a
number of options, odbc, dbi, php, etc etc. in the end, you have to
query a, process the result and send the answer to b.
There is a PostgreSQL project explicitly for this type of thing...
dbi-link: http://pgfoundry.org/projects/dbi-link/
Sincerely,
Joshua D. Drake
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
