On Sunday, May 22, 2022, Saladin <
jiaoshuntian@highgo.com> wrote:
The output i expected:
pg_largeobject_metadata and pg_largeobject in both database A and database
B should have rows.Shouldn't only in database A.So, i can use large object
functions
to operate large_objectin remote table or foreign table.
This is an off-topic email for the -hackers mailing list. -general is the appropriate list.
Your expectation is simply unsupported by anything in the documentation.
If you want to do what you say you will need to use dblink (and the file needs to be accessible to the remote server directly) and directly execute entire queries on the remote server, the FDW infrastructure simply does not work in the way you are expecting.
Or just use bytea.
David J.