jdbc2_fdw icon indicating copy to clipboard operation
jdbc2_fdw copied to clipboard

ERROR: invalid option "query"

Open santanab opened this issue 9 years ago • 0 comments

CREATE FOREIGN TABLE b (process_date char(9)) server jdbc_as4002 options (query 'SELECT R FROM schema.table');

ERROR: invalid option "query" HINT: Valid options in this context are: use_remote_estimate, updatable, schema_name, table_name, use_remote_estimate

How can execute a select from where, if I can't use a query clause?

Thanks.

santanab avatar Oct 26 '15 22:10 santanab