postgres_scanner
postgres_scanner copied to clipboard
DuckDB Secret Manager doesn't support URLs
The Postgres extension page for Postgres mentions you can use URIs to connect, but I can't seem to be able to use them to work with Secrets.
It'd be great if we could use these for Secrets Manager.
https://github.com/duckdb/duckdb-postgres/blob/main/src/postgres_extension.cpp#L105
There seems to be quite a few parameters missing as well, Postgres has a bunch of environment variables that would be needed for various deployments. https://www.postgresql.org/docs/17/libpq-envars.html