hello there does anyone here use duckdb to query postgres?
ATTACH postgres_attach(‘hostaddr=192.168.0.1 port=5432 dbname=mydb connect_timeout=20 user=postgres
password=masterkey’);
always returns like this ^
QL Error: Invalid Error: Failed to prepare COPY ”
COPY (SELECT NULL FROM “public”.”acessohabilitacao” WHERE ctid BETWEEN ‘(0,0)’::tid AND ‘(4294967295,0)’::tid) TO STDOUT (FORMAT binary);
FROM ibroker.main.acessohabilitacao;`
ERRO: erro de sintaxe em ou próximo a “binary”
LINE 2: …’::tid AND ‘(4294967295,0)’::tid) TO STDOUT (FORMAT binary);
^
the query
SELECT
[‘idacessohabilitacao’]
FROM ibroker.main.acessohabilitacao
WHERE ctid BETWEEN ‘(0,0)’::tid AND ‘(4294967295,0)’::tid) TO STDOUT (FORMAT binary);