Sharing data between databases

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Sharing data between databases
Date: 2011-05-12 00:48:48
Message-ID: BANLkTikt8FOQyh7KASE3MpJjyD3UbUNE+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Cheers.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua Tolley 2011-05-12 01:12:43 Re: Debug Contrib/cube code
Previous Message Joshua J. Kugler 2011-05-11 22:46:09 Re: Urgent Order