On Thu, Sep 3, 2009 at 6:10 PM, Sergey Samokhin<prikrutil(at)gmail(dot)com> wrote:
> Hello.
>
> Is this possible to move a table from one machine to another and then
> redirect queries involving this table to the remote host in a
> transparent way?
>
> As I have just read, tablespaces let us define where given tables
> should be stored on the file system. What I'm looking for is like
> tablespaces, but with the ability to use a remote host as location.
The way to do it that makes me cringe, would be to remote mount (NFS,
CIFS) another file system from a remote machine and put the table
there.
The better way is probably to look up pl/proxy and use that.