Pettis, Barry wrote:
Now this PostGreSQL "server" has many databases in it. Some of which I have access to. I don't want to reinvent the wheel ( so to speak ) by having to replicate the table in my database. Then having to create routines that will extract from A to replicate in B. How do I reference a table in another database?
There is an add-on in contrib/ called "dblink" that lets you connect to a remote database. There's also a dbilink project that uses Perl.
Also to respond in the thread... Do I just reply to the message?
Reply-All is the default on the pg lists. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
