Search Result: dbname - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

Documentation DuckDB 1.3 ドキュメント全文検索

DuckDB 1.3 ドキュメント全文検索

Results of 1 - 3 of about 3 for dbname (0.002 sec.)

PostgreSQL Extension – DuckDB 11663: This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove ... gres_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 wor ... 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' ); Configuration The ATTACH command takes a ... n strings and commonly used parameters. A full list of available parameters can be found in the PostgreSQL documentation . dbname=postgresscanner host=localhost port=5432 dbname=mydb connect_timeout=10 Name Description Default dbname Database name [use ...; https://man.mtool.work/duckdb/1.3/core_extensions/postgres.html

PostgreSQL Import – DuckDB 9115: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... he table "mytable" from the schema "public" in the database "mydb" SELECT * FROM postgres_scan ( 'host=localhost port=5432 dbname=mydb' , 'public' , 'mytable' ); The first parameter to the postgres_scan function is the PostgreSQL connection string , a ... 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 Alternatively, the entire database can be att ... s a regular database. -- Attach the PostgreSQL database using the given 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 ...; https://man.mtool.work/duckdb/1.3/guides/database_integration/postgres.html

Python API – DuckDB 7106: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... ase: 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/1.3/clients/python/overview.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work