Simple set of rules for type casting common Ruby types to PostgreSQL.
OIDs of supported type casts are not hard-coded in the sources, but are retrieved from the PostgreSQL’s pg_type table in
Query params are type casted based on the class of the given value.
Higher level libraries will most likely not make use of this class, but use their own derivation of
PG::TypeMapByClass or another set of rules to choose suitable encoders and decoders for the values to be sent.
conn = PG::Connection.new # Assign a default ruleset for type casts of input and output values. conn.type_map_for_queries = PG::BasicTypeMapForQueries.new(conn) # Execute a query. The Integer param value is typecasted internally by PG::BinaryEncoder::Int8. # The format of the parameter is set to 0 (text) and the OID of this parameter is set to 20 (int8). res = conn.exec_params( "SELECT $1",  )
- encode_array_as R
Public Class Methods
Create a new type map for query submission
registry: Custom type registry, nil for default global registry
Procobject which is called, if no type for an parameter class is not defined in the registry.
Public Instance Methods
Change the mechanism that is used to encode ruby array values
:array: Encode the ruby array as a PostgreSQL array. The array element type is inferred from the class of the first array element. This is the default.
:json: Encode the ruby array as a JSON document.
:record: Encode the ruby array as a composite type row.
"_type": Encode the ruby array as a particular PostgreSQL type. All PostgreSQL array types are supported. If there’s an encoder registered for the elements
type, it will be used. Otherwise a string conversion (by
value.to_s) is done.