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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
