Re: [GENERAL] Copy Data between different databases

] Gesendet: Mittwoch, 4. März 2015 15:48 An: Adrian Klaver Cc: Tim Semmelhaack; pgsql-general@postgresql.org Betreff: Re: [GENERAL] Copy Data between different databases Hi Adrian: On Wed, Mar 4, 2015 at 1:03 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com> > wrote: ​As you pointed,

Re: [GENERAL] Copy Data between different databases

On 3/3/15 8:18 AM, Tim Semmelhaack wrote: When I run a much simpler version of the query with the -c "Select .." option it works. Because the sql-scripts are quite long, I don't to do it without the -f option. When you say quite long... are you trying to do multiple commands in q1 or q2? As in

Re: [GENERAL] Copy Data between different databases

Hi Adrian: On Wed, Mar 4, 2015 at 1:03 AM, Adrian Klaver wrote: > > ​As you pointed, my bet is in the -f case COPY FROM STDIN expects the >> data on the file ( otherwise pg_dumps would not work ), but your >> sugestion seems to have a problem of double redirection, let me elaborate: >> > > Well

Re: [GENERAL] Copy Data between different databases

On 03/03/2015 10:09 AM, Francisco Olarte wrote: Hi Adrian: On Tue, Mar 3, 2015 at 4:44 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 03/03/2015 06:18 AM, Tim Semmelhaack wrote: Hi, I want to copy data between two servers (Version 9.1 and 9.4) I've

Re: [GENERAL] Copy Data between different databases

Have you considered using dblink() or foreign data wrappers to transfer the data? You can do a select from source, insert into target using one of these methods. RC > On Mar 3, 2015, at 12:09 PM, Francisco Olarte wrote: > > Hi Adrian: > > On Tue, Mar 3, 2015 at 4:44 PM, Adrian Klaver

Re: [GENERAL] Copy Data between different databases

Hi Adrian: On Tue, Mar 3, 2015 at 4:44 PM, Adrian Klaver wrote: > On 03/03/2015 06:18 AM, Tim Semmelhaack wrote: > >> Hi, >> >> I want to copy data between two servers (Version 9.1 and 9.4) >> >> I've tried >> >> ​​ >> psql -h host1 -U user1 -d db1 -f /q1.sql | psql -h host2 -U user2 -d db2 >>

Re: [GENERAL] Copy Data between different databases

On 03/03/2015 06:18 AM, Tim Semmelhaack wrote: Hi, I want to copy data between two servers (Version 9.1 and 9.4) I've tried psql -h host1 -U user1 -d db1 -f /q1.sql | psql -h host2 -U user2 -d db2 -f /q2.sql Both sql-scripts include the COPY (SELECT ...) TO STDOUT or COPY (SELECT ...) TO STD

[GENERAL] Copy Data between different databases

Hi, I want to copy data between two servers (Version 9.1 and 9.4) I've tried psql -h host1 -U user1 -d db1 -f /q1.sql | psql -h host2 -U user2 -d db2 -f /q2.sql Both sql-scripts include the COPY (SELECT ...) TO STDOUT or COPY (SELECT ...) TO STDIN As a result nothing is copied. When I run a