Class

PgsqlParams

Description 

final class Pgsql.Params : GObject.Object
{
  /* No available fields */
}

A container for PostgreSQL query parameters.

PgsqlParams is used to build parameterized queries for PostgreSQL databases. It provides type-safe methods to add parameters of various PostgreSQL types, which are then used when executing queries through pgsql_connection_query().

Parameters are added in order using the various pgsql_params_add_*() methods. Once a PgsqlParams object is used in a query, it becomes frozen and cannot be modified further.

Ancestors

Constructors

pgsql_params_new

Creates a new PgsqlParams object.

Instance methods

pgsql_params_add_boolean

Adds a boolean parameter as PostgreSQL BOOLEAN type.

pgsql_params_add_bytea

Adds binary data parameter as PostgreSQL BYTEA type.

pgsql_params_add_date

Adds a date parameter as PostgreSQL DATE type.

pgsql_params_add_date_time

Adds a date/time parameter as PostgreSQL TIMESTAMPTZ type (with time zone).

pgsql_params_add_float4

Adds a 32-bit floating point parameter as PostgreSQL REAL type.

pgsql_params_add_float8

Adds a 64-bit floating point parameter as PostgreSQL DOUBLE PRECISION type.

pgsql_params_add_int16

Adds a 16-bit integer parameter as PostgreSQL SMALLINT type.

pgsql_params_add_int32

Adds a 32-bit integer parameter as PostgreSQL INTEGER type.

pgsql_params_add_int64

Adds a 64-bit integer parameter as PostgreSQL BIGINT type.

pgsql_params_add_json

Adds a JSON parameter as PostgreSQL JSON type.

pgsql_params_add_jsonb

Adds a JSON parameter as PostgreSQL JSONB type.

pgsql_params_add_null

Adds a NULL parameter to the parameter list.

pgsql_params_add_numeric

Adds a numeric parameter as PostgreSQL NUMERIC type.

pgsql_params_add_string

Adds a string parameter as PostgreSQL TEXT type.

pgsql_params_add_text

Adds a text parameter as PostgreSQL TEXT type.

pgsql_params_add_time

Adds a time parameter as PostgreSQL TIME type.

pgsql_params_add_timestamp

Adds a timestamp parameter as PostgreSQL TIMESTAMP type (without time zone).

pgsql_params_add_timestamptz

Adds a timestamp parameter as PostgreSQL TIMESTAMPTZ type (with time zone).

pgsql_params_add_uuid

Adds a UUID parameter as PostgreSQL UUID type.

pgsql_params_add_varchar

Adds a variable-length character string parameter as PostgreSQL VARCHAR type.

Methods inherited from GObject (43)

Please see GObject for a full list of methods.

Signals

Signals inherited from GObject (1)
GObject::notify

The notify signal is emitted on an object when one of its properties has its value set through g_object_set_property(), g_object_set(), et al.

Class structure 

struct PgsqlParamsClass {
  GObjectClass parent_class;
  
}

No description available.

Class members
parent_class: GObjectClass

No description available.