Results of 1 - 10 of about 25 for identifier (0.002 sec.)
- DuckDB_% Metadata Functions 13948
- 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
...umn Description Type database_name The name of the database that contains the column object. VARCHAR database_oid Internal identifier of the database that contains the column object. BIGINT schema_name The SQL name of the schema that contains the table obj...ect that defines this column. VARCHAR schema_oid Internal identifier of the schema object that contains the table of the column. BIGINT table_name The SQL name of the table that defines the c...olumn. VARCHAR table_oid Internal identifier (name) of the table object that defines the column. BIGINT column_name The SQL name of the column. VARCHAR column_index Th... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Full-Text Search Extension 11872
- Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension . Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repos
...ARCHAR Qualified name of specified table, e.g., 'table_name' or 'main.table_name' input_id VARCHAR Column name of document identifier, e.g., 'document_identifier' input_values... VARCHAR Column names of the text fields to be indexed (vararg), e.g., 'text_f...OOLEAN Whether to maintain the FTS index with triggers after inserts and deletes on the input table. Requires the document identifier column to be declared NOT NULL or PRIMARY KEY . Defaults to 0 This PRAGMA builds the index under a newly created schema. T...eval macro is created that can be used to search the index. Name Type Description input_id VARCHAR Column name of document identifier, e.g., 'document_identifier' query_string VARCHAR The string to search the index for fields VARCHAR Comma-separated list o... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Keywords and Identifiers 11540
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
...l character, e.g., SELECT 123 AS 1col is invalid. They cannot contain whitespaces (including tabs and newline characters). Identifiers can be quoted using double-quote characters ( " ). Quoted identifiers can use any keyword, whitespace or special characte...r, e.g., "SELECT" and " § ? ¶ " are valid identifiers. Double quotes can be escaped by repeating the quote character, e.g., to create an identifier named IDENTIFIER "X" , use..."IDENTIFIER ""X""" . New As of DuckDB 2.0, identifiers can also be quoted using backtick characters ( ` ), following exactly the same... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- Geometry Functions 9033
- 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
...rsects_Extent Returns true if the geometries bounding boxes intersect ST_CRS Returns the Coordinate Reference System (CRS) identifier of the geometry ST_SetCRS Sets the Coordinate Reference System (CRS) identifier of the geometry ST_GeomFromWKB function |...:GEOMETRY | | Result | true | | Alias | && | ST_CRS function | Description | Returns the Coordinate Reference System (CRS) identifier of the geometry | | Example | ST_CRS('POINT(1 2)'::GEOMETRY('OGC:CRS84')) | | Result | OGC:CRS84 | ST_SetCRS function | De...scription | Sets the Coordinate Reference System (CRS) identifier of the geometry | | Example | typeof(ST_SetCRS('POINT(1 2)'::GEOMETRY, 'OGC:CRS84')) | | Result | GEOMETRY('OGC:CRS84') |... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- SQL Quirks 8983
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...auses (same as the LIMIT clause) but is semantically applied before both (unlike the LIMIT clause). Implicit Conversion of Identifiers in Table Function Arguments DuckDB historically allowed a bare, unbound identifier to be used as a table function argumen...uch_file.csv') . Deprecated As of DuckDB 2.0, this implicit conversion is deprecated. By default DuckDB still converts the identifier but logs a warning; use an explicit string literal instead, for example glob('no_such_file.csv') . The behavior is control...led by the table_function_identifier_conversion setting: DEFAULT : convert the identifier but log a warning. ENABLE_IMPLICIT_STRING : convert silently (the pre... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
- Geometry Data Type 8601
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...of mistakes, DuckDB makes it possible to explicitly associate a CRS with a GEOMETRY column. This is done by passing a CRS "identifier" as a parameter of the GEOMETRY type. For example, a column of type GEOMETRY('OGC:CRS84') stores geometries that are assoc...iated with the "OGC CRS84" coordinate reference system. CRS identifiers in DuckDB are always strings. OGC:CRS84 is the identifier for a common geographic coordinate system spanning the whole gl...e where the X coordinate represents longitude and the Y coordinate represents latitude. DuckDB only knows this because the identifier OGC:CRS84 is registered as a known CRS in the system catalog. Warning Storing GEOMETRY columns that carry a CRS identifier... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Utility Functions 8236
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...ame of the currently active database. current_query() Return the current query as a string. current_query_id() Returns the identifier of the current query as a UBIGINT . current_schema() Return the name of the currently active schema. Default is main. curr...the expression. Expression can be a column, constant, or SQL expression. txid_current() Returns the current transaction's identifier, a UBIGINT value. It will assign a new one if the current transaction does not have one already. typeof(expression) Return...tring. | | Example | current_query() | | Result | SELECT current_query(); | current_query_id() | Description | Returns the identifier of the current query as a UBIGINT . | | Example | current_query_id() | | Result | various | current_schema() | Description... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- Amazon RDS with IAM Authentication 8169
- Managed PostgreSQL databases on Amazon RDS and Aurora can authenticate with short-lived IAM tokens instead of a static password. DuckDB supports this through the postgres and aws extensions: the aws extension generates the token from an AWS
...( TYPE rds, PROVIDER credential_chain, CHAIN 'env;sso', REGION '⟨eu-west-1⟩', RDS_USER '⟨postgres⟩', RDS_HOST '⟨instance⟩.⟨identifier⟩.⟨region⟩.rds.amazonaws.com', RDS_PORT '5432' ); Then create a secret of type postgres that references it via AWS_RDS_SECR...ed by the rds secret is used (and refreshed) automatically: CREATE SECRET pg_rds_secret ( TYPE postgres, HOST '⟨instance⟩.⟨identifier⟩.⟨region⟩.rds.amazonaws.com', PORT '5432', USER '⟨postgres⟩', DATABASE '⟨postgres⟩', SSLMODE require, AWS_RDS_SECRET aws_r... - https://man.mtool.work/duckdb/2.0/guides/database_integration/rds_iam.html
- CREATE MACRO Statement 8119
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...s for CREATE MACRO . The simplified syntax for creating a macro is: CREATE [OR REPLACE] [TEMPORARY] MACRO [IF NOT EXISTS] ⟨identifier⟩( [⟨parameters⟩] ) AS [TABLE] ⟨expression⟩; The identifier consists of the macro's name, which can be any valid SQL identi...an attempt will fail with a Macro Function already exists error. An IF NOT EXISTS clause may occur immediately before the identifier, and has the effect of only creating the macro if it does not already exist. Either the OR REPLACE or the IF NOT EXISTS cl...laration is: ⟨parameter-name⟩ [⟨datatype⟩] [ := ⟨default-value⟩ ] The parameter name is mandatory and can be any valid SQL identifier. Parameter names must be unique within the parameter list. An attempt to define multiple parameters with the same name res... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Profile and Monitor 7904
- 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
...t enables the event. Enabling Emission Monitoring is opt-in per connection: set the jdbc_jfr_memory_monitor property to an identifier for the connection's database instance. The value is an arbitrary label that is attached to every event as its component f...er DuckDB memory tag per JFR tick, with the following fields: Field Type Description component String Application-supplied identifier, the jdbc_jfr_memory_monitor value. tag String DuckDB memory tag, such as BASE_TABLE , HASH_TABLE , or ALLOCATOR . dbAddre...ss long Native address of the DuckDB instance, a stable per-instance identifier. memoryUsageBytes long Bytes currently allocated for this tag. temporaryStorageBytes long Bytes spilled to temporary stora... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
DuckDB 2.0 Documentation / man.mtool.work