Re: Sharing data between databases

On 05/12/2011 08:48 AM, Tim Uckun wrote:
> What is the preferred way to share tables between databases?
>
> I read about dblink but it doesn't seem optimal because it needs to
> pull in the entire query every time the view is referenced so it might
> be highly inefficient if I am trying to join a dblinked table with a
> "local" table.

There isn't a good one for PostgreSQL, really.

Most people use replication tools like slony, londiste or bucardo to
replicate shared tables between databases, so each has a copy.

SQL/MED may improve the situation - at some point, possibly.

--
Craig Ringer