Postgres Pro
Downloads
Home   >   mailing lists

Re: query a table from one database to another - Mailing list pgsql-general

From Joshua Tolley
Subject Re: query a table from one database to another
Date
Msg-id 4b606dbf.9613f30a.5b83.0451@mx.google.com
Whole thread Raw
In response to query a table from one database to another  (AI Rumman <rummandba@gmail.com>)
Responses Re: query a table from one database to another  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
Tree view 
On Wed, Jan 27, 2010 at 02:52:58PM +0600, AI Rumman wrote:
>    I am using Postgresql 8.3
>
>    I have two databases:
>    db1
>    db2
>
>    db1 holds a table tab1.
>
>    Is it possible to get the value of the above tab1 in db2 database?
>
>    Regards

You'll need something like the dblink contrib module to get one database to
talk to another.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
Attachment

pgsql-general by date:

Previous
From: "Aycock, Jeff R."
Date:
Subject: Re: syntax error during function call
Next
From: Adrian Klaver
Date:
Subject: Re: syntax error during function call