After doing lots of reading it looks like dblink might be a great solution for this. After trying to insert dblink.sql into the database, I just get a series of errors:
ERROR: stat failed on file '$libdir/dblink': No such file or directory
This is not a dblink error per se, but rather a "dynamic library can't be found" error. At a shell prompt, run the following:
pg_config --pkglibdir
That should output the $libdir path (e.g. /usr/local/pgsql/lib). Now go look there for dblink.<dll-ext-for-yourOS> (e.g. dblink.so). If it isn't there, do a "make clean" and show us the output of
make
make install
make installcheck
Joe
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
