The query as written should work for both the embedded server as well as a remote server.

Can you provide the query PSQL and the exact error message/information that is being thrown?