chdb 拡張機能リファレンスドキュメント

# CREATE EXTENSION chdb;
CREATE EXTENSION

# SELECT * FROM chdb_query('version()') AS (version text);
 version
----------
 26.7.2.1
(1 row)

SELECT pgchdb_version();

SELECT version
  FROM pg_get_loaded_modules()
 WHERE module_name = 'chdb';

SELECT * FROM chdb_query('SELECT version()') AS (version text);

GRANT EXECUTE ON FUNCTION chdb_query(text) TO chdb_admin;

SELECT * FROM chdb_query(
    'SELECT number AS n, number * number FROM numbers(5) ORDER BY n'
) AS (n int2, p int);

 n | p
---+----
 0 |  0
 1 |  1
 2 |  4
 3 |  9
 4 | 16
(5 rows)

SET chdb.max_memory = '1 GB';

SET chdb.max_threads = 4;

SET chdb.max_parsing_threads = 2;