Postgres Pro
Downloads
Home   >   mailing lists

postgres_fdw : disable extended queries - Mailing list pgsql-general

From Nicolas Paris
Subject postgres_fdw : disable extended queries
Date
Msg-id CA+ssMOT+jzdhHeZ1tTZjp=rerhkQP3_YTJu_6GLmJai0WN1mvg@mail.gmail.com
Whole thread Raw
Responses Re: postgres_fdw : disable extended queries  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view
Hello,

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

Thanks,

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Exclude pg_largeobject form pg_dump
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: Exclude pg_largeobject form pg_dump