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