Merlin Moncure wrote:
> On Jan 4, 2008 11:51 AM, Afewtips.com <afewtips@gmail.com> 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