omni_sqlite

pig build pkg omnigres         # 构建 RPM / DEB 包

pig repo add pgsql -u          # 添加仓库并更新缓存

CREATE EXTENSION omni_sqlite;

SELECT 'CREATE TABLE user_config (key text, value text)'::omni_sqlite.sqlite;

CREATE TABLE customer (
    id   bigserial PRIMARY KEY,
    name text NOT NULL,
    data omni_sqlite.sqlite DEFAULT 'CREATE TABLE user_config (key text, value text);'
);

UPDATE customer
SET data = omni_sqlite.sqlite_exec(data,
    $$INSERT INTO user_config VALUES ('color', 'blue')$$)
RETURNING *;

SELECT omni_sqlite.sqlite_exec('CREATE TABLE tab (val text)',
    'INSERT INTO tab VALUES ($1)', row('hello'));

SELECT * FROM omni_sqlite.sqlite_query(
    (SELECT data FROM customer),
    'SELECT rowid, key, value FROM user_config')
AS (id bigint, key text, value text);

-- 序列化为 bytea：
SELECT omni_sqlite.sqlite_serialize('CREATE TABLE foo (x)');
-- 从 bytea 反序列化：
SELECT omni_sqlite.sqlite_deserialize(bytea_data);