jdbc2_fdw
jdbc2_fdw copied to clipboard
ERROR: invalid option "query"
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.