index_key()

Generate index keys for a named index on a table (specified by a path struct with required 'table' and optional 'catalog'/'schema' fields) from key column arguments. Currently only supports ART indexes.

Reference: DuckDB 2.0.0

Arguments & returns

index_key(path, name, …)

Scalar
Overload link pathname … Varargs Returns
#01 STRUCTVARCHAR ANY BLOB

… accepts a variable number of arguments of the type shown.

Catalog examples

SELECT
  index_key (
    {'schema': 'main', 'table': 'tbl3'},
    'tbl3_idx',
    key1,
    key2,
    key3
  );