dblink without running the full query remotely?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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(
    '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.


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux