Search Result: address - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

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

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

Results of 1 - 6 of about 6 for address (0.389 sec.)

ORDER BY Clause – DuckDB 12320: 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 ... information on collations, see the Collation page . Examples All examples use this example table: CREATE OR REPLACE TABLE addresses AS SELECT '123 Quack Blvd' AS address , 'DuckTown' AS city , '11111' AS zip UNION ALL SELECT '111 Duck Duck Goose Ln' , ... Duck Goose Ln' , 'Duck Town' , '11111' UNION ALL SELECT '111 Duck Duck Goose Ln' , 'Duck Town' , '11111-0001' ; Select the addresses, ordered by city name using the default NULL order and default order: SELECT * FROM addresses ORDER BY city ; Select the ... addresses, ordered by city name in descending order with nulls at the end: SELECT * FROM addresses ORDER BY city DESC NULLS LAST ; ...; https://man.mtool.work/duckdb/1.3/sql/query_syntax/orderby.html

inet Extension – DuckDB 10985: 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 Extensions Copy Markdown inet Extension The inet extension defines the INET data type for storing IPv4 and IPv6 Internet addresses. It supports the CIDR notation for subnet masks (e.g., 198.51.100.0/22 , 2001:db8:3c4d::/48 ). Installing and Loading Th ... a2f:1a2b Operations on INET Values INET values can be compared naturally, and IPv4 will sort before IPv6. Additionally, IP addresses can be modified by adding or subtracting integers. CREATE TABLE tbl ( cidr INET ); INSERT INTO tbl VALUES ( '127.0.0.1' ... .1 127.0.0.1 2001:db8:3c4d:15::1a2f:1a2b/96 2001:db8:3c4d:15::1a2f:1a2b netmask Function Computes the network mask for the address's network. CREATE TABLE tbl ( cidr INET ); INSERT INTO tbl VALUES ( '192.168.1.5/24' ), ( '127.0.0.1' ), ( '2001:db8:3c4d: ...; https://man.mtool.work/duckdb/1.3/core_extensions/inet.html

PostgreSQL Import – DuckDB 8024: 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 ... t. 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 [OS user name] password PostgreSQL password dbname Database name ...; https://man.mtool.work/duckdb/1.3/guides/database_integration/postgres.html

Iceberg Extension – DuckDB 7860: 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 ... s option ensures that some path resolution is performed, which allows scanning Iceberg tables that are moved. You can also address specify the current manifest directly in the query, this may be resolved from the catalog prior to the query, in this exam ...; https://man.mtool.work/duckdb/1.3/core_extensions/iceberg/overview.html

SQLite Extension – DuckDB 7860: 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 ... ables, but the underlying data is read directly from the SQLite tables in the file at query time. SHOW TABLES ; name actor address category city country customer customer_list film film_actor film_category film_list film_text inventory language payment ...; https://man.mtool.work/duckdb/1.3/core_extensions/sqlite.html

PostgreSQL Extension – DuckDB 7713: 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 ... timeout=10 Name Description Default dbname Database name [user] host Name of host to connect to localhost hostaddr Host IP address localhost passfile Name of file passwords are stored in ~/.pgpass password PostgreSQL password (empty) port Port number 54 ...; https://man.mtool.work/duckdb/1.3/core_extensions/postgres.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work