omni_schema

Overview

Version

Build

You can build the RPM / DEB packages for omnigres using pig build:

pig build pkg omnigres         # build RPM / DEB packages

Install

You can install omnigres directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

pig install omnigres;          # Install for current active PG version

pig ext install -y omnigres -v 18  # PG 18
pig ext install -y omnigres -v 17  # PG 17
pig ext install -y omnigres -v 16  # PG 16
pig ext install -y omnigres -v 15  # PG 15
pig ext install -y omnigres -v 14  # PG 14

dnf install -y omnigres_18       # PG 18
dnf install -y omnigres_17       # PG 17
dnf install -y omnigres_16       # PG 16
dnf install -y omnigres_15       # PG 15
dnf install -y omnigres_14       # PG 14

apt install -y postgresql-18-omnigres   # PG 18
apt install -y postgresql-17-omnigres   # PG 17
apt install -y postgresql-16-omnigres   # PG 16
apt install -y postgresql-15-omnigres   # PG 15
apt install -y postgresql-14-omnigres   # PG 14

Create Extension:

CREATE EXTENSION omni_schema CASCADE;  -- requires: omni_sql, omni_vfs, omni_polyfill, omni_yaml, dblink, postgres_fdw, omni_types, omni_cloudevents

Usage

omni_schema: Advanced schema management tooling

The omni_schema extension manages application schemas through migrations and object reloading from filesystems.

Run Migrations

SELECT * FROM omni_schema.migrate_from_fs(omni_vfs.local_fs('/path/to/migrations'));

Recursively finds .sql files, applies them in path name order, skips previously applied migrations. Tracks execution in omni_schema.migrations table.

Reload Schema Objects

SELECT * FROM omni_schema.load_from_fs(omni_vfs.local_fs('/path/to/project'));

Reloads functions, policies, and views from the filesystem. To ignore a file, place omni_schema[[ignore]] in it (typically in a comment).

Migrations Table

Multi-Language Support

Supports SQL, PL/pgSQL (.sql), Python (.py), Perl (.pl), Tcl (.tcl), and Rust (.rs). Use the SQL[[...]] directive to specify function signatures:

# times_ten.py
# SQL[[create function times_ten(a integer) returns integer]]
return a * 10