1

Topic: The data on a link to push, instead of to pull out

Such problem.
insert in the table remote, and it is better create table on remote base.
As to make it a python I know. And whether is not present standard  means?

2

Re: The data on a link to push, instead of to pull out

Rinka777 wrote:

Such problem.
insert in the table remote, and it is better create table on remote base.
As to make it a python I know. And whether is not present standard  means?

dblink

3

Re: The data on a link to push, instead of to pull out

Dark blue Elephant;
It is necessary that select from current basis insert in remote.
SELECT dblink_build_sql_insert (' foo ', ' and here should be select from current basis ');
Here in this a place I do not understand as

4

Re: The data on a link to push, instead of to pull out

psql dbtest
SELECT dblink_exec
(
' dbname=postgres ';
' INSERT INTO tbla
SELECT id, time
FROM dblink
(
"dbname=dbtest";
"SELECT id, time FROM tblb"
)
AS t (id integer, time integer)
WHERE time> 1000;'
);

5

Re: The data on a link to push, instead of to pull out

Rinka777;
Look on FDW.

6

Re: The data on a link to push, instead of to pull out

vyegorov wrote:

Rinka777;
Look on FDW.

Thanks, already. Does not approach

7

Re: The data on a link to push, instead of to pull out

Rinka777 wrote:

it is passed...
Thanks, already. Does not approach

l/, /
And what not so?
It is not put?
Or manual optimization is necessary?
In  cause local , to the basis.
If laziness transferred mn-in from its part to format in literals.
Type

_ ('  ', $tama$insert into.... select * from dblink (' tuta ', $tutta$SElect...... $tutta $) as t (fields_lists) $tama $)

Etc.