Results of 1 - 10 of about 11 for host (0.003 sec.)
- MySQL Extension – DuckDB 11558
- 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
...SQL To make a MySQL database accessible to DuckDB use the ATTACH command with the mysql or the mysql_scanner type: ATTACH 'host=localhost user=root port=0 database=mysql' AS mysqldb ( TYPE mysql ); USE mysqldb ; Configuration The connection string de...extension tries to read it from an environment variable. Setting Default Environment variable database NULL MYSQL_DATABASE host localhost MYSQL_HOST password MYSQL_PWD port 0 MYSQL_TCP_PORT socket NULL MYSQL_UNIX_PORT user current user MYSQL_USER ssl...ion can also be specified with secrets . The following syntax can be used to create a secret. CREATE SECRET ( TYPE mysql , HOST '127.0.0.1' , PORT 0 , DATABASE mysql , USER 'mysql' , PASSWORD '' ); The information from the secret will be used when AT... - https://man.mtool.work/duckdb/1.3/core_extensions/mysql.html
- PostgreSQL Extension – DuckDB 10918
- 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
...and with the postgres or postgres_scanner type. To connect to the public schema of the PostgreSQL instance running on localhost in read-write mode, run: ATTACH '' AS postgres_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 working with large instances, i...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 as input either a libpq conne... - https://man.mtool.work/duckdb/1.3/core_extensions/postgres.html
- PostgreSQL Import – DuckDB 10918
- 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
..._scan function: -- Scan the 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 Postgr...ist of connection arguments provided in {key}={value} format. Below is a list of valid arguments. Name Description Default host Name of host to connect to localhost hostaddr Host IP address localhost port Port number 5432 user PostgreSQL user name [O...eSQL database as if it was 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 regul... - https://man.mtool.work/duckdb/1.3/guides/database_integration/postgres.html
- inet Extension – DuckDB 10384
- 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
...d:15::1a2f:1a2b' ); SELECT cidr FROM tbl ORDER BY cidr ASC ; cidr 127.0.0.1 127.0.0.11 2001:db8:3c4d:15::1a2f:1a2b fe80::7 host Function The host component of an INET value can be extracted using the HOST() function. CREATE TABLE tbl ( cidr INET ); I...NSERT INTO tbl VALUES ( '192.168.0.0/16' ), ( '127.0.0.1' ), ( '2001:db8:3c4d:15::1a2f:1a2b/96' ); SELECT cidr , host ( cidr ) FROM tbl ; cidr host(cidr) 192.168.0.0/16 192.168.0.0 127.0.0.1 127.0.0.1 2001:db8:3c4d:15::1a2f:1a2b/96 2001:db8...;') │ │ varchar │ ├────────────────────────┤ │ & │ └────────────────────────┘ 関連キーワード cidr ffff network inet subnet host netmask address broadcast extension addresses Computes Predicate equal escape varchar unescape Documentation Core Extensio... - https://man.mtool.work/duckdb/1.3/core_extensions/inet.html
- File Access with the file: Protocol – DuckDB 9726
- 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
...the file: Protocol DuckDB supports using the file: protocol. It currently supports the following formats: file:/some/path (host omitted completely) file:///some/path (empty host) file://localhost/some/path ( localhost as host) Note that the following...ve path) file://some/path (double-slash path) Additionally, the file: protocol currently does not support remote (non-localhost) hosts. 関連キーワード path host localhost supports protocol currently following formats relative Documentation Guides For... - https://man.mtool.work/duckdb/1.3/guides/file_formats/file_access.html
- MySQL Import – DuckDB 8766
- 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
...ql ; Usage After the mysql extension is installed, you can attach to a MySQL database using the following command: ATTACH 'host=localhost user=root port=0 database=mysqlscanner' AS mysql_db ( TYPE mysql , READ_ONLY ); USE mysql_db ; The string used b...is a list of valid arguments. Any options not provided are replaced by their default values. Setting Default database NULL host localhost password port 0 socket NULL user current user You can directly read and write the MySQL database: CREATE TABLE t...ension documentation . 関連キーワード mysql MySQL database extension command user connection list directly installed using host localhost port arguments provided Documentation Guides Database Integration Copy Markdown Import query running 関連するペー... - https://man.mtool.work/duckdb/1.3/guides/database_integration/mysql.html
- Safe Mode – DuckDB 7254
- 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
...ing external files other than the database file that it was initially connected to and prevented from interacting with the host file system. This has the following effects: The following dot commands are disabled: .cd .excel .import .log .once .open... - https://man.mtool.work/duckdb/1.3/clients/cli/safe_mode.html
- Iceberg REST Catalogs – DuckDB 7148
- 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
...E SECRET iceberg_secret ( TYPE ICEBERG , CLIENT_ID ' admin ' , CLIENT_SECRET ' password ' , OAUTH2_SERVER_URI ' http://irc_host_url.com/v1/oauth/tokens ' ); If you already have a Bearer token, you can pass it directly to your CREATE SECRET statement... - https://man.mtool.work/duckdb/1.3/core_extensions/iceberg/iceberg_rest_catalogs....
- Sharing Macros – DuckDB 7148
- 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
...──────┤ │ 25M │ └─────────┘ As one would expect, the macro gets persisted in the database. But this also means that we can host it on an HTTPS endpoint and share it with anyone! We have published this macro on blobs.duckdb.org . You can try it from D... - https://man.mtool.work/duckdb/1.3/guides/snippets/sharing_macros.html
- FILTER Clause – DuckDB 7041
- 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
...vot, as columns must be defined prior to runtime in SQL. However, this kind of statement can be dynamically generated in a host programming language to leverage DuckDB's SQL engine for rapid, larger than memory pivoting. First generate an example dat... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/filter.html
DuckDB 1.3 Documentation / man.mtool.work