An addon???? Being self schooled in databases to me this seems to be a kludge. If you work in a large company environment the odds that someone somewhere is all ready storing or collecting data that you need ( by this I mean base data ) could probably be pretty high. So why, if PostGre is so old/established, is the ability to share information between databases have to be done through an add on. So let me give an example to help clarify. 1. I work in a manufacturing environment 2. Our product can have 150 to 450 different / unique process steps 3. We have a description of each process step 4. So with a product we can look at it's flow and see the descriptions of each step Now say person A pulls this information on a daily basis and then summarizes the product manufacturing information and creates a table that has say the total number of process modules ( aka group of steps ), the total number of steps, the total number of a particular type of step. Now let's say that another person NEEDS that very information in a query or table in their own database. Are you saying that each person needs to generate this. To me the sharing of information seems to be so basic that within a said postgre server, that as along as you have access to a said database you should be able to say use the data stored here. And that that ability should be a rudimentary ability not an addon. Reason why I don't' have ability to install addon's onto the database. Regards, Barry Pettis -----Original Message----- From: Richard Huxton [mailto:dev@xxxxxxxxxxxx] Sent: Thursday, March 27, 2008 3:45 AM To: Pettis, Barry Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Using tables in other PostGreSQL database 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
