Nicolas Paris wrote:
> I have a 9.6 pg instance, and I am trying to link a foreign postgresql database that do not accept
> extended queries. (only simple queries https://www.postgresql.org/docs/current/static/protocol.html )
>
> When I run a query against the foreign pg instance thought postres_fdw, it looks like it sends a
> transaction containing
>
> DECLARE c1 CURSOR FOR
> SELECT customer_id FROM foodmart.customer
>
> -> is there a way to run a simple query with postgres_fdw such:
>
> SELECT customer_id FROM foodmart.customer
No, it is part of the design that cursors are used, so that rows can be
fetched one at a time and concurrent DML statements can be run.
You might consider using dblink.
Yours,
Laurenz Albe