Results of 1 - 6 of about 6 for dbname (0.001 sec.)
- PostgreSQL Extension 12685
- 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
...stgres_db (TYPE postgres); To connect to the PostgreSQL instance with the given parameters in read-only mode, run: ATTACH 'dbname=postgres user=postgres host=127.0.0.1' AS db (TYPE postgres, READ_ONLY); By default, all schemas are attached. When workin...e instances, it can be useful to only attach a specific schema. This can be accomplished using the SCHEMA command. ATTACH 'dbname=postgres user=postgres host=127.0.0.1' AS db (TYPE postgres, SCHEMA 'public'); The transaction isolation level can be set...ption. Supported values are READ COMMITTED , REPEATABLE READ , and SERIALIZABLE ; the default is REPEATABLE READ . ATTACH 'dbname=postgres user=postgres host=127.0.0.1' AS db (TYPE postgres, ISOLATION_LEVEL 'READ COMMITTED'); Warning Avoid including cr... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- PostgreSQL Extension and the Secret Manager 9596
- 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
...t database while still using the same credentials, we can override only the database name in the following manner. ATTACH 'dbname=my_other_db' AS postgres_db (TYPE postgres); By default, created secrets are temporary. Secrets can be persisted using the...guration options. The following options are named after the corresponding connection options of libpq : HOST HOSTADDR PORT DBNAME USER PASSWORD PASSFILE REQUIRE_AUTH CHANNEL_BINDING CONNECT_TIMEOUT CLIENT_ENCODING OPTIONS APPLICATION_NAME FALLBACK_APPL...CLIENT_ID OAUTH_CLIENT_SECRET OAUTH_SCOPE The following options are renamed to the corresponding keys: DATABASE – alias to DBNAME HOSTNAME – alias to HOST USERNAME – alias to USER Instead of separate connection options, the full connection URI can be s... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- PostgreSQL Import 9596
- To run a query directly on a running PostgreSQL database, the postgres extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL postgres; To load t
...addr Host IP address localhost port Port number 5432 user PostgreSQL user name [OS user name] password PostgreSQL password dbname Database name [user] passfile Name of file passwords are stored in ~/.pgpass -- Attach the PostgreSQL database using the g...iven connection string ATTACH 'host=localhost port=5432 dbname=mydb' AS test (TYPE postgres); -- The table "tbl_name" can now be queried as if it is a regular table SELECT * FROM test.t... - https://man.mtool.work/duckdb/2.0/guides/database_integration/postgres.html
- CONNECT and DISCONNECT Statements 8097
- New Support for the CONNECT and DISCONNECT statements was introduced in DuckDB 2.0. The CONNECT statement routes the current session to a remote database, so that subsequent queries execute on that remote and their results stream back. DISC
...e.g., postgres: , followed by a connection string for that database (here, a libpq connection string ): CONNECT 'postgres:dbname=mydb host=localhost'; SELECT count(*) FROM orders; -- runs on the PostgreSQL server DISCONNECT; Syntax CONNECT { ⟨attached... - https://man.mtool.work/duckdb/2.0/sql/statements/connect.html
- Python API 7457
- Installation To use the DuckDB Python client, visit the Python installation page . The latest stable version of the DuckDB Python client is 2.0.0. Installation The DuckDB Python API can be installed using pip : pip install duckdb . Please s
...mory database: import duckdb con = duckdb.connect() con.sql("SELECT 42 AS x").show() Persistent Storage The duckdb.connect(dbname) creates a connection to a persistent database. Any data written to that connection will be persisted, and can be reloaded... - https://man.mtool.work/duckdb/2.0/clients/python/overview.html
- ATTACH and DETACH Statements 7348
- DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db'; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'fil
...th in two steps: If the path begins with a recognized scheme prefix followed by a colon, such as sqlite:file.db , postgres:dbname=postgres , or mysql:db=mysql , the scheme determines the type. The prefix must be at least two characters long and must no... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work