Results of 1 - 4 of about 4 for UUIDs (0.002 sec.)
- Create Synthetic Data 12242
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...nge [0, 1) , which you can scale and cast into any numeric range: SELECT (random() * 100)::INTEGER AS score FROM range(3); UUIDs Several utility functions generate universally unique identifiers, which make good synthetic primary keys: uuid() and its...alias uuidv4() generate random (version 4) UUIDs, uuidv7() generates time-ordered (version 7) UUIDs, and gen_random_uuid() is an alias for uuid() : SELECT uuidv7() AS id F... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- PostgreSQL Extension 9246
- 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
...y were normal DuckDB tables, but the underlying data is read directly from PostgreSQL at query time. SHOW ALL TABLES; name uuids SELECT * FROM uuids; u 6d3d2541-710b-4bde-b3af-4711738636bf NULL 00000000-0000-0000-0000-000000000001 ffffffff-ffff-ffff-f... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- Numeric Types 8044
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...SELECT sqrt(2) > '-inf', 'nan' > sqrt(2); (sqrt(2) > '-inf') ('nan' > sqrt(2)) true true Universally Unique Identifiers ( UUID s) DuckDB supports universally unique identifiers (UUIDs) through the UUID type. These use 128 bits and are represented int... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Configuration 7433
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...join order approximately instead of exactly. UBIGINT 12 arrow_large_buffer_size Whether Arrow buffers for strings, blobs, UUIDs and bits should be exported using large buffers. BOOLEAN false arrow_lossless_conversion Whenever a DuckDB type does not h... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work