Types

Types

apgConnection* = ref object of RootRef

apgConnection object represents connection to PostgreSQL server.

PPGResult* = ref object of RootRef

PPGResult object represents single result dataset of executed SQL query.

apgResult* = ref object of RootRef

apgResult object represents result's dataset of executed SQL query or queries. apgResult can hold results of multiple SQL queries, so it have an array of PPGResult objects, which can be accessed via [] procedure.

apgPool* = ref object of RootRef

apgPool object represents pool of connections to PostgreSQL server

apgNotify* = object
  channel*: string # channel name
  payload*: string # payload data
  bepid*: int      # PID of PostgreSQL's worker process

apgNotify object represents PostgreSQL's asynchronous notify (Asynchronous notification).

Row* = seq[string]

Row object represents row of a dataset.

JsonB* = distinct JsonNode

JsonB object represents PostgreSQL's jsonb type. This type can be used to represent Nim's JsonNode object as PostgreSQL's jsonb type in SQL query.

Json* = distinct JsonNode

Json object represents PostgreSQL's json type. This type can be used to represent Nim's JsonNode object as PostgreSQL's json type in SQL query.