SQL reference
Use this reference to look up Pivot’s supported SQL syntax and behavior. Applications connect through the PostgreSQL wire protocol; SQL support is specific to Pivot.
Statements
Section titled “Statements”Read data with SELECT, write rows with INSERT or COPY, and define tables with CREATE TABLE.
Functions and operators
Section titled “Functions and operators”Find aggregates, string and regex functions, date functions, and other expressions. Each category includes signatures, argument restrictions, and examples.
Browse functions and operators →
Data types
Section titled “Data types”Choose column and expression types, including integers, decimals, timestamps, and semi-structured values. The reference distinguishes types that can be stored in tables from types available only in expressions and results.
System tables
Section titled “System tables”Read catalog, file, and memory metadata through the read-only tables of the
system schema.
Beyond SQL
Section titled “Beyond SQL”- CLI reference -
pivot open,pivot server, and shell commands. - Configuration file - every key of the server’s YAML file, with sub-pages for datastores and storage credentials and users and authentication.
Compatibility
Section titled “Compatibility”A SQL statement can parse successfully and still require an unsupported plan, expression, or type. Individual command and function pages describe the supported forms and their restrictions.
BEGIN, COMMIT, and ROLLBACK are accepted for driver compatibility, but
statements commit individually. Read transaction behavior
before relying on a client’s transaction handling.