duckdb / duckdb/duckdb-postgres

Postgres_scan should be able to read a persistent secret

Open
#331 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

Similar to `ATTACH`, you should be able to use a persistent secret. My current and only option at the moment is to attach the whole database even though I am only interested in 1 table.
```sql
CREATE PERSISTENT SECRET my_persistent_secret (
TYPE postgres,
HOST 'localhost,
PORT 5432,
DATABASE my_db,
USER 'my_user',
PASSWORD 'my_password'
);
SELECT * FROM postgres_scan('', 'public', 'my_table');
```

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.