Results of 1 - 10 of about 13 for Sequences (0.002 sec.)
- CREATE SEQUENCE Statement 14569
- The CREATE SEQUENCE statement creates a new sequence number generator. Examples Generate an ascending sequence starting from 1: CREATE SEQUENCE serial; Generate sequence from a given start number: CREATE SEQUENCE serial START 101; Generate
...odd numbers using INCREMENT BY : CREATE SEQUENCE serial START WITH 1 INCREMENT BY 2; Generate a descending sequence starting from 99: CREATE SEQUENCE serial START WITH 99 I...ot allowed and will result in error, e.g.: Sequence Error: nextval: reached maximum value of sequence "serial" (10) CREATE SEQUENCE serial START WITH 1 MAXVALUE 10; CYCLE allows cycling through the same sequence repeatedly: CREATE SEQUENCE serial START WI...TH 1 MAXVALUE 10 CYCLE; Creating and Dropping Sequences Sequences can be created and dropped similarly to other catalog items. Overwrite an existing sequence: CREATE OR REPLACE S... - https://man.mtool.work/duckdb/2.0/sql/statements/create_sequence.html
- DuckDB Environment 9607
- DuckDB provides a number of functions and PRAGMA options to retrieve information on the running DuckDB instance and its environment. Version The version() function returns the version number of DuckDB. SELECT version() AS version; version v
...rved words duckdb_optimizers() : the available optimization rules in the DuckDB instance duckdb_schemas() : schemas duckdb_sequences() : sequences duckdb_settings() : settings duckdb_tables() : base tables duckdb_temporary_files() : the temporary files Du... - https://man.mtool.work/duckdb/2.0/guides/meta/duckdb_environment.html
- DuckDB_% Metadata Functions 8920
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...the content of the secret as a string. Sensitive pieces of information, e.g., the access key, are redacted. VARCHAR duckdb_sequences The duckdb_sequences() function provides metadata about the sequences available in the DuckDB instance. Column Description...ARCHAR tags A map of string key–value pairs. MAP(VARCHAR, VARCHAR) temporary Whether this sequence is temporary. Temporary sequences are transient and only visible within the current connection. BOOLEAN start_value The initial value of the sequence. This...alue that is added to the current value of the sequence to draw the next value from the sequence. BIGINT cycle Whether the sequence should start over when drawing the next value would result in a value outside the range. BOOLEAN last_value The last value... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Literal Types 8621
- DuckDB has special literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEG
...apostrophe) character in a string literal, use '' . For example, SELECT '''' AS s returns ' . To enable some common escape sequences, such as \n for the newline character, prefix a string literal with e (or E ). SELECT e'Hello\nworld' AS msg; ┌───────────...───┐ │ msg │ │ varchar │ ├──────────────┤ │ Hello\nworld │ └──────────────┘ The following backslash escape sequences are supported: Escape sequence Name ASCII code \b backspace 8 \f form feed 12 \n newline 10 \r carriage return 13 \t tab 9... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- LibreDB Studio SQL Editor 8516
- LibreDB Studio is an open-source, self-hosted, browser-based SQL editor. It runs as a single server, either via npx , Docker, or a native package, and is reached through the browser rather than installed as a desktop application. LibreDB St
...Establish Connection to save it. The connection appears in the sidebar. Expand it to browse the tables, views, macros, and sequences in the database. Open a query tab, write SQL, and run it with Run or Ctrl + Enter ( Cmd + Enter on macOS). Now you are rea... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/libredb_studio.html
- VisuaLeaf SQL Editor 8516
- VisuaLeaf is a cross-platform desktop database client for Windows, macOS, and Linux. Besides a SQL editor, it includes a visual query builder, entity-relationship diagrams, and charts built from query results. VisuaLeaf ships with the DuckD
...it before connecting. The connection appears in the Connections panel. Expand it to browse the schemas, tables, views, and sequences in the database. Right-click the database and choose New SQL Editor , write a query, and click Run All to see the results.... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/visualeaf.html
- COMMENT ON Statement 8428
- The COMMENT ON statement allows adding metadata to catalog entries (tables, columns, etc.). It follows the PostgreSQL syntax . Examples Create a comment on a TABLE : COMMENT ON TABLE test_table IS 'very nice table'; Create a comment on a CO
...EW s: SELECT comment FROM duckdb_views(); List comments on INDEX s: SELECT comment FROM duckdb_indexes(); List comments on SEQUENCE s: SELECT comment FROM duckdb_sequences(); List comments on TYPE s: SELECT comment FROM duckdb_types(); List comments on MA... - https://man.mtool.work/duckdb/2.0/sql/statements/comment_on.html
- EXPORT and IMPORT DATABASE Statements 8322
- The EXPORT DATABASE command allows you to export the contents of the database to a specific directory. The IMPORT DATABASE command allows you to then read the contents again. Examples Export the database to the target directory target_direc
...SE The EXPORT DATABASE command exports the full contents of the database – including schema information, tables, views and sequences – to a specific directory that can then be loaded again. The created directory will be structured as follows: target_direc... - https://man.mtool.work/duckdb/2.0/sql/statements/export.html
- Execution Format 8023
- Vector is the container format used to store in-memory data during execution. DataChunk is a collection of Vectors, used for instance to represent a column list in a PhysicalProjection operator. Data Flow DuckDB uses a vectorized query exec
...are physically stored as an offset and an increment value. Sequence vectors are useful for efficiently storing incremental sequences. They are generally emitted for row identifiers. Unified Vector Format These properties of the different vector formats ar... - https://man.mtool.work/duckdb/2.0/internals/vector.html
- Create Synthetic Data 7935
- 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
...ds a string by repeating another, which is useful for padding values to a target length: SELECT repeat('ab', 3) AS padded; Sequences A sequence produces a monotonically increasing series of numbers. nextval('sequence_name') advances the sequence and retur... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
DuckDB 2.0 Documentation / man.mtool.work