Results of 1 - 10 of about 11 for address (0.002 sec.)
- ORDER BY Clause 13371
- ORDER BY is an output modifier. Logically it is applied near the very end of the query (just prior to LIMIT or OFFSET , if present). The ORDER BY clause sorts the rows on the sorting criteria in either ascending or descending order. In addi
...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', 'Du...Duck 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; Order by city and then by zip code, both using the default orderings: SELECT * FROM addre... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/orderby.html
- inet Extension 11487
- 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 The inet extension will be tran
...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'::IN....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:15::1a2...255.255 2001:db8:3c4d:15::1a2f:1a2b/96 ffff:ffff:ffff:ffff:ffff:ffff::/96 network Function Returns the network part of the address, zeroing out whatever is to the right of the netmask. CREATE TABLE tbl (cidr INET); INSERT INTO tbl VALUES ('192.168.1.5/2... - https://man.mtool.work/duckdb/2.0/core_extensions/inet.html
- Profile and Monitor 8979
- Overview The JDBC driver exposes several ways to observe a running or completed query: cancelling and timing out queries, polling query progress, retrieving profiling output, and emitting memory-usage events through Java Flight Recorder . T
...ifier, the jdbc_jfr_memory_monitor value. tag String DuckDB memory tag, such as BASE_TABLE , HASH_TABLE , or ALLOCATOR . dbAddress long Native address of the DuckDB instance, a stable per-instance identifier. memoryUsageBytes long Bytes currently alloca...are also present. Stack traces are disabled for this event. Attribution The monitor is keyed on the native DuckDB instance address, the dbAddress field, not on the JDBC connection. There is one sample stream per distinct instance, so shared memory is no...one closes; opening a new opted-in connection afterward starts a fresh monitor. Whether two getConnection calls share a dbAddress follows the same rules as instance caching : URL or operation Same dbAddress ? jdbc:duckdb: (unnamed in-memory) No — a fre... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- PostgreSQL Import 8979
- 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
...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/2.0/guides/database_integration/postgres.html
- SQLite Extension 8037
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...tables, 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/2.0/core_extensions/sqlite.html
- Logging 7877
- DuckDB implements a logging mechanism that provides users with detailed information about events such as query execution, performance metrics and system events. Warning Logs may contain sensitive information, including secrets and credentia
...particularly problematic when debugging crashes, as messages generated immediately before a crash might not be written. To address this, the buffer size can be configured as follows: CALL enable_logging(storage = 'memory', storage_config = {'buffer_size... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- Migrating to DuckDB 2.0 7877
- DuckDB 2.0.0 is packed with new features and performance improvements, including query optimization and asynchronous I/O. It also ships a small set of breaking changes, most notably a new default storage format, which DuckDB versions before
...assess whether your workload is mission-critical. For such workloads, consider waiting for upcoming patch releases, which address issues that surface shortly after a major release. To help facilitate this, the DuckDB development team extended support f... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- Quack Remote Protocol 7877
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...guments . By default the server refuses to bind anything other than a local hostname. To listen on an externally-reachable address, pass allow_other_hostname = true : {:.codebox-server} CALL quack_serve('quack:0.0.0.0:9494', allow_other_hostname = true)... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Reference 7877
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...RCHAR (empty) Deployment provider ( ec2 , docker , local , ...). whoami_hostname VARCHAR (empty) Network hostname / public address. whoami_region VARCHAR (empty) Deployment region. whoami_started_at VARCHAR (empty) Node start time (ISO 8601 timestamp).... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- PostgreSQL Extension 7735
- 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
...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/2.0/core_extensions/postgres/overview.html
DuckDB 2.0 Documentation / man.mtool.work