Results of 1 - 3 of about 3 for psql (0.001 sec.)
- PostgreSQL Extension and the Secret Manager 11831
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...es extension automatically. Connecting with IAM Authentication from Command Line This section illustrates the process with psql utility, not with DuckDB. This method can be used to check the configuration before setting up DuckDB secrets. When IAM au...thentication is performed using psql command line tool, the following are the AWS-recommended connection steps: Generate authentication token using aws CLI. Pa...ss this token as a password connection option: bash export RDSHOST="database-1-instance-1.xxx.eu-west-1.rds.amazonaws.com" psql "host=$RDSHOST port=5432 dbname=postgres user=postgres sslmode=require password=$(aws rds generate-db-auth-token --hostnam... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- Amazon RDS with IAM Authentication 8594
- Managed PostgreSQL databases on Amazon RDS and Aurora can authenticate with short-lived IAM tokens instead of a static password. DuckDB supports this through the postgres and aws extensions: the aws extension generates the token from an AWS
...See Also Postgres extension secrets — AWS RDS IAM Authentication — the full reference, including verifying the setup with psql first. AWS extension — the credential chain options available to the rds secret.... - https://man.mtool.work/duckdb/2.0/guides/database_integration/rds_iam.html
- PostgreSQL Extension 7440
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...e produced will be the equivalent of copying the file to PostgreSQL using DuckDB and then dumping it from PostgreSQL using psql or another client: DuckDB: COPY postgres_db.tbl FROM 'data.parquet'; PostgreSQL: \copy tbl TO 'data.bin' WITH (FORMAT BINA... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work