From: | "P(dot) Broennimann" <peter(dot)broennimann(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | dblink / Insert several records into remote table |
Date: | 2013-08-05 09:22:53 |
Message-ID: | CACm4aU_dthEBh4LYeu4t_1A_uOHRkB=s4n38yjP7bFjJ6L4aOg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
I'd like to use dblink to insert records (several) from a local table to a
remote table. Is it possible to do this in one statement? Something like:
insert into <remotetable> select col1, col2, col3 from <localtable>
Can someone give me an example or tell me what commands to use? What I have
so far:
l_connect_str = 'hostaddr=192.168.10.21 port=5432 dbname=db1
user=postgres password=test';
perform public.dblink_connect('con1', l_connect_str);
...
perform public.dblink_disconnect('conn1');
P.S: I could "pull" the data (select) from the remote DB using dblink, but
I prefer to "push" the data (insert) from the local DB to reduce the
network traffic.
Thanks,
Peter
From | Date | Subject | |
---|---|---|---|
Next Message | KONDO Mitsumasa | 2013-08-05 09:40:10 | Re: Bottlenecks with large number of relation segment files |
Previous Message | John R Pierce | 2013-08-05 08:42:13 | Re: Bottlenecks with large number of relation segment files |