Results of 1 - 10 of about 58 for Binary (0.001 sec.)
- Extension Distribution 11636
- Platforms Extension binaries are distributed for several platforms (see below). For platforms where packages for certain extensions are not available, users can build them from source and install the resulting binaries manually . Most offic
.... For example, for the Python client, see the Loading and Installing Extensions section in the Python API documentation . Binary Compatibility To avoid binary compatibility issues, the binary extensions distributed by DuckDB are tied both to a specifi...c DuckDB version and a platform . This means that DuckDB can automatically detect binary compatibility between it and a loadable extension. When trying to load an extension that was compiled for a different vers...load the extension. DuckDB stores this compatibility information in a metadata footer appended to the end of the extension binary. Warning Do not run strip on an extension binary. Stripping removes or corrupts the appended metadata footer, after which... - https://man.mtool.work/duckdb/2.0/extensions/extension_distribution.html
- Blob Type 11387
- Name Aliases Description BLOB BYTEA , BINARY , VARBINARY Variable-length binary data The blob ( B inary L arge OB ject) type represents an arbitrary binary object stored in the database system. The blob type can contain any type of binary d
... - https://man.mtool.work/duckdb/2.0/sql/data_types/blob.html
- PostgreSQL Extension Functions 10787
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...Example FROM postgres_query('db11', 'SELECT $1::INTEGER, $2::TEXT', params=row(42::INTEGER, 'foo'::VARCHAR)) read_postgres_binary FROM read_postgres_binary(file_path VARCHAR[, ⟨optional named parameters⟩]) -> TABLE Reads PostgreSQL binary dump files fr...om file system. Parameters file_path ( VARCHAR ): FS path to the binary dump file in a PostgreSQL format. Optional named parameters: columns ( STRUCT ): type mapping in form of the column_name -...> column_type structure. buffer_size ( UBIGINT , default: 32KB): size of the read buffer in bytes. Returns Contents of the binary dump file as a table. Example COPY (SELECT 42::INTEGER AS a, 'foo'::VARCHAR AS b) TO 'path/to/test.bin' (FORMAT postgres_b... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Geometry Functions 10172
- This section describes the functions for examining and manipulating GEOMETRY values. The spatial extension provides additional functions for working with GEOMETRY values, which are documented in the Spatial Functions section. Geometry Opera
...0 0, 10 20)'::GEOMETRY true Built-in Geometry Functions Name Description ST_GeomFromWKB Creates a geometry from Well-Known Binary (WKB) representation ST_AsWKB Returns the Well-Known Binary (WKB) representation of the geometry ST_AsWKT Returns the Well...ference System (CRS) identifier of the geometry ST_GeomFromWKB function | Description | Creates a geometry from Well-Known Binary (WKB) representation | | Example | ST_GeomFromWKB('\x01\x01\x00\x00\x00\x00\x00\x00\x00\x00\x00\xF0?\x00\x00\x00\x00\x00\x...00\x00@') | | Result | POINT(1 2) | ST_AsWKB function | Description | Returns the Well-Known Binary (WKB) representation of the geometry | | Example | ST_AsWKB('POINT(1 2)'::GEOMETRY) | | Result | \x01\x01\x00\x00\x00\x00\... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- Load Extensions 9572
- Overview DuckDB-Wasm's (dynamic) extension loading is modeled after regular DuckDB's extension loading, with a few relevant differences due to the difference in platform. A growing subset of core, community, and external extensions is suppo
...mat Extensions in DuckDB are binaries to be dynamically loaded via dlopen . A cryptographical signature is appended to the binary. An extension in DuckDB-Wasm is a regular Wasm file to be dynamically loaded via Emscripten's dlopen . A cryptographical s...al disk. The LOAD semantic in native embeddings of DuckDB is to (optionally) perform signature checks and dynamic load the binary with the main DuckDB binary. In DuckDB-Wasm, INSTALL performs no durable installation, because there is no cross-session s...Most are fetched on the fly when they are autoloaded or explicitly loaded, rather than being bundled into the DuckDB-Wasm binary. For example: -- Explicitly load a core extension LOAD icu; -- Load spatial for geospatial support INSTALL spatial; LOAD s... - https://man.mtool.work/duckdb/2.0/clients/wasm/extensions.html
- PostgreSQL Extension 9572
- 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
...and DuckDB: COPY postgres_db.tbl TO 'data.parquet'; COPY postgres_db.tbl FROM 'data.parquet'; These copies use PostgreSQL binary wire encoding . DuckDB can also write data using this encoding to a file which you can then load into PostgreSQL using a c...our choosing if you would like to do your own connection management: COPY 'data.parquet' TO 'pg.bin' WITH (FORMAT postgres_binary); The file produced will be the equivalent of copying the file to PostgreSQL using DuckDB and then dumping it from Postgre...psql or another client: DuckDB: COPY postgres_db.tbl FROM 'data.parquet'; PostgreSQL: \copy tbl TO 'data.bin' WITH (FORMAT BINARY); You may also create a full copy of the database using the COPY FROM DATABASE statement : COPY FROM DATABASE postgres_db... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- Unofficial and Unsupported Platforms 9572
- Warning The platforms listed on this page are not officially supported. The build instructions are provided on a best-effort basis. Community contributions are very welcome. DuckDB is built and distributed for several platforms with differe
...tures (such as PowerPC) are not supported by DuckDB. While DuckDB can likely be built on such architectures, the resulting binary may exhibit correctness errors on certain operations. Therefore, its use is not recommended. RISC-V Architectures Native B..... -DCMAKE_BUILD_TYPE=Release make -j$(nproc) Build time is approximately 2 hours on an 8-core SpacemiT K1. The resulting binary works out of the box: ./duckdb -c “SELECT 'Hello from RISC-V' AS message;” ┌───────────────────┐ │ message │ │ varchar │ ├...3 │ └───────┴─────────┘ The DuckDB Python package also builds successfully from source on riscv64: pip install duckdb --no-binary duckdb Build with RVV (RISC-V Vector Extension) On boards with RVV 1.0 support (e.g., SpacemiT K3 with vlen 256), you can... - https://man.mtool.work/duckdb/2.0/dev/building/unofficial_and_unsupported_platfo...
- Extensions 9455
- DuckDB has a flexible extension mechanism that allows for dynamically loading extensions. Extensions can enhance DuckDB's functionality by providing support for additional file formats, introducing new types, and domain-specific functionali
...eekly extension download statistics as JSON files: core extensions and community extensions . Built-In Extensions DuckDB's binary distribution comes standard with a few built-in extensions. They are statically linked into the binary and can be used as...built-in available in DuckDB, two steps need to happen: Extension installation is the process of downloading the extension binary and verifying its metadata. During installation, DuckDB stores the downloaded extension and some metadata in a local direc...ds to. This means that installation needs to happen only once. Extension loading is the process of dynamically loading the binary into a DuckDB instance. DuckDB will search the local extension directory for the installed extension, then load it to make... - https://man.mtool.work/duckdb/2.0/extensions/overview.html
- Troubleshoot 9089
- Overview This page collects common issues encountered when using the DuckDB JDBC driver, together with their workarounds. If you run into a problem that is not covered here, search the driver's issue tracker on GitHub. Driver Class Not Foun
...Result and ResultSet.getString() returns the bytes rendered as an escaped string rather than the expected text. Enable the binary_as_string setting to read these columns as VARCHAR : try (Statement stmt = conn.createStatement()) { stmt.execute("SET bin...ry_as_string = true;"); } The same option can be passed to read_parquet directly, for example read_parquet('file.parquet', binary_as_string = true) . This behavior is tracked in duckdb-java issue #113 . Native Image: NoSuchMethodError When Opening a Co...driver registration, configuration options, and instance behavior behind many connection-time errors. Parquet Files — the binary_as_string setting and other options for reading Parquet string columns correctly.... - https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
- Blob Functions 8840
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...haracters into literal encoding. from_base64(string) Converts a base64 encoded string to a character string ( BLOB ). from_binary(value) Alias for unbin . from_hex(value) Alias for unhex . hex(blob) Converts blob to VARCHAR using hexadecimal encoding....o_base64(blob) Converts a blob to a base64 encoded string. to_hex(blob) Alias for hex . unbin(value) Converts a value from binary representation to a blob. unhex(value) Converts a value from hexadecimal representation to a blob. arg1 || arg2 | Descript...| Example | to_base64('A'::BLOB) | | Result | QQ== | | Alias | base64 | unbin(value) | Description | Converts a value from binary representation to a blob. | | Example | unbin('0110') | | Result | \x06 | | Alias | from_binary | unhex(value) | Descripti... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
DuckDB 2.0 Documentation / man.mtool.work