CREATE SECRET with PASSFILE: how to?

[ericemc3]

What happens?

Error on creating PG secret with a passfile

To Reproduce

CREATE SECRET (
    PASSFILE 'C:\...\.pgpass'
) ;

SQL Error: java.sql.SQLException: Binder Error: Unknown parameter 'passfile' for secret type 'postgres' with default provider 'config'

OS:

Win11

PostgreSQL Version:

16

DuckDB Version:

v1.3.0-dev3365

DuckDB Client:

jdbc

Full Name:

eric mauviere

Affiliation:

icem7

Have you tried this on the latest main branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree