MIME-Version: 1.0
From: Wells Oliver <wells.oliver@gmail.com>
Date: Fri, 25 Aug 2023 11:20:23 -0700
Message-ID: 
 <CAOC+FBWCx3iunwdXYRKmr89O2qXNeOHgSTvv13Cju73LNcvKEA@mail.gmail.com>
Subject: dblink without running the full query remotely?
To: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000e19e40603c368c4"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOC%2BFBWCx3iunwdXYRKmr89O2qXNeOHgSTvv13Cju73LNcvKEA%40mail.gmail.com>
Precedence: bulk

--0000000000000e19e40603c368c4
Content-Type: text/plain; charset="UTF-8"

Per the documentation -- *dblink fetches the entire remote query result
before returning any of it to the local system* -- I am guessing the answer
is no, but I wondered if there was some way to do something like this:

create view myview as;
select * from dblink(
    'server',
    'select id from sometable')
cols(id bigint);

And then

select * from myview where id = 123;

Where that remote sometable might have a bajillion rows and the local where
would be passed to it otherwise it's days and days for all rows to be
returned and then filtered.

-- 
Wells Oliver
wells.oliver@gmail.com <wellsoliver@gmail.com>

--0000000000000e19e40603c368c4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Per the documentation -- <i>dblink fetches the entire remo=
te query result before returning any of it to the local system</i> -- I am =
guessing the answer is no, but I wondered if there was some way to do somet=
hing like this:<div><br></div><div><font face=3D"monospace" size=3D"1">crea=
te view myview as;<br>select * from dblink(<br>=C2=A0 =C2=A0 &#39;server=
9;,<br>=C2=A0 =C2=A0 &#39;select id from sometable&#39;)<br>cols(id bigint)=
;</font><br><br>And then</div><div><br></div><div><font face=3D"monospace" =
size=3D"1">select * from myview where id =3D 123;</font></div><div><br></di=
v><div>Where that remote sometable might have a bajillion rows and the loca=
l where would be passed to it otherwise it&#39;s days and days for all rows=
 to be returned and then filtered.</div><div><br><div><span class=3D"gmail_=
signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature" =
data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><div>Wells Oliver<br><a=
 href=3D"mailto:wellsoliver@gmail.com" target=3D"_blank">wells.oliver@gmail=
.com</a></div></div></div></div></div></div>

--0000000000000e19e40603c368c4--