On Thu, Sep 3, 2009 at 6:10 PM, Sergey Samokhin<prikrutil@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general