Skip to article frontmatterSkip to article content
Site not loading correctly?

This may be due to an incorrect BASE_URL configuration. See the MyST Documentation for reference.

Postgres

Kconfig: CONFIG_MODULE_POSTGRESGClasses: C_POSTGRES

PostgreSQL integration — async query execution with automatic JSON-to-SQL type mapping. Requires libpq.

C_POSTGRES

Async PostgreSQL client with an internal query queue. Maps JSON types to PostgreSQL types:

JSON typePostgreSQL type
stringtext
integerbigint
realdouble precision
booleanboolean
objecttext (JSON serialized)

Requires libpq-dev and CONFIG_MODULE_POSTGRES=y.

Queries are queued and run asynchronously over one or more connection channels.

Commands: list-size / list-queue (pending-query queue), view-channels, authzs. Trace levels: messages.

Consumed by the dba_postgres yuno (the __postgres__ service), which adds the DBA layer on top.