Infinidat / infi.clickhouse_fdw

A PostgreSQL foreign data wrapper for ClickHouse
BSD 3-Clause "New" or "Revised" License
54 stars 4 forks source link

LIMIT TO clause generates error #1

Closed nsscan closed 6 years ago

nsscan commented 6 years ago

Example syntax shows import of schema can be limited to specific tables using 'LIMIT TO ('tablename')' however this syntax generates an error

ERROR: syntax error at or near "limit"

The correct syntax has the LIMIT TO clause before the FROM SERVER clause (see https://www.postgresql.org/docs/10/static/sql-importforeignschema.html)