duckdb / duckdb/duckdb-postgres

Can I directly call Greenplum functions using Postgre extensions

Open
#303 0 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.