search

heimir-sverrisson / jdbc2_fdw

JDBC Foreign Data Wrapper for PostgreSQL
26 stars 16 forks source link

ERROR: invalid option "query" #2

Open santanab opened 8 years ago

santanab commented 8 years ago

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.