Re: [GENERAL] Synchronizing Data?

[joe]

This might be the stupidest idea ever, but it seems logical to me, so
tell me what you think:

What if I use the TCP/IP connection to connect the two databases - Then
I SELECT * INTO a temporary table on the remote server. Once that is
completed (and any relational tables), I drop the table on the remote
server, and rename the temp one to the name of the one I dropped (make
sense?). I'm sure there are some major flaws with my theory (I'm fairly
new to postgresql)...please let me know. Thanks,

Joe