duckdb / duckdb/duckdb-postgres
Can I directly call Greenplum functions using Postgre extensions
Open
- Dominant language
- C++
- Stars
- 372
- Forks
- 105
- Avg merge
- 10h 19m
- Merged PRs (30d)
- 18
Description
When I write the following code in DuckDB:
CREATE SECRET ps (
TYPE postgres,
HOST '${ip}',
PORT ${port},
DATABASE ${dbname},
USER '${user}',
PASSWORD '${password}'
);
ATTACH 'dbname=${dbname}' AS gp (TYPE postgres, SECRET ps);
CALL postgres_execute('gp', 'SELECT * FROM gp.dw.getcombinesn(''HF52RT0006'')');
I encounter the following error:
ERROR: cross-database references are not implemented: gp.dw.getcombinesn
Is it possible to directly call Greenplum functions using the Postgres extension in DuckDB?
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.