$root.$sessions.POSTGRESQL

Parent: $root.$sessions

Properties

Object specific
$backendpid The process ID of the backend server process handling this connection
$bytesreceived The number of bytes received through the session object since logon. Assigning to this property resets the value to zero.
$bytessent The number of bytes sent through the session object since logon. Assigning to this property resets the value to zero.
$char38touuid If kTrue, Omnis character fields of length 38 are mapped to UUID
$char39tooid If kTrue, Omnis character fields of length 39 are mapped to OID
$codepage The code page used to interpret non-Unicode character data, a kUni… constant (see codepage constants)
$commitdelay The delay (in milliseconds) between each commit retry
$commitretries The number of times a commit operation will retry before conceding
$database Name of the session database
$debugfile If assigned, the DAM writes debug information to the specified file
$debuglevel Specifies the level of debug information required
$debugsize The maximum size of debug file generated before truncation occurs. Assigning zero disables truncation.
$encoding The Unicode encoding used by the database (see encoding constants) kSessionEncodingAnsi kSessionEncodingUtf16 kSessionEncodingUtf32 kSessionEncodingUtf8
$fetch64bitints If kTrue, 64-bit integers are fetched into 64-bit Integer fields. If kFalse, they are fetched as 32-bit Integers and truncated accordingly
$logontimeout Number of seconds before a connection attempt times out
$maxvarchar The maximum size above which Omnis Character types are mapped to text
$numericprecision The precision used when mapping the Omnis number (dp) type to 'numeric'
$options Allows additional logon parameters to be specified
$port The port number for the TCP/IP connection
$protocolversion Version of the protocol in use
$quotedidentifier If kTrue, table instances and session methods will generate quoted column & table name identifiers
$readonly If kTrue, manual transactions are read-only
$schema The schema name to be used when qualifying table names
$sequencetoint If kTrue, the Omnis Sequence type is mapped to INTEGER instead of SERIAL
$serializable If kTrue, manual transactions will use Serializable isolation level
$service Service name to use for additional connection parameters
$socket The file descriptor number of the connection socket to the server.
$timezone The time zone to be used when $usetimezone is kTrue
$unicode If kTrue, Unicode data types/mappings are used. If kFalse, DAM reverts to ANSI behavior
$usetimezone If kTrue, date/time time zone delimiters are used
Standard $allowstransactions $apiversion $autobegintran $blobsize $charmap $commitmode $damname $defaultdate $emptydateisnull $errorcode $errortext $hostname$ident $lobchunksize $lobthreshold $maptable $name $nativeerrorcode $nativeerrorpending $nativeerrortext $password $rollbackmode $sessionobject$sessionobjref $sqldecimalseparator $sqlstripspaces $sqlthousandseparator $state $transactionmode $username $version

Methods

Object specific
$addcustomtype Creates a custom datatype mapping for the specified field size
$cancel Requests that the server abandon processing of the current command(s)
$clearcustomtypes Clears the internal list of custom character types
$connectstatus Returns the status of the current connection
$escapebinary Escapes binary data for use as a quoted literal value within an SQL statement
$getssl Returns qtrue if the connection is using SSL and optionally, info about the connection. Requires an SSL-enabled client library
$listen Listens for the specified notification channel name and calls obj.$notify() when triggered
$lobclose Closes the specified large object
$lobcreate Creates a new large object, optionally using the specified OID
$lobexport Exports the specified large object from the database into a local file
$lobimport Imports the contents of a local file into a new large object, optionally using the specified OID
$lobopen Opens an existing large object for reading or writing
$lobread Reads data from an existing large object
$lobseek Changes the current read/write position for the specified large object
$lobtell Obtains the current read/write position for the specified large object
$lobtruncate Resizes a large object to the specified length
$lobunlink Unlinks the specified large object from the database
$lobwrite Writes data to an existing large object
$newstatement $newstatement([cStatementname]) Creates and returns a new dynamic instance of a statement object for the session; typically used to return a new statement object to an object variable with no subtype specified
POSTGRESQL statement object
$newstatementref $newstatementref([cStatementname]) Creates and returns a new dynamic instance of a statement object for the session, to be used with an Object reference variable; typically used to return a new statement to an object reference variable
POSTGRESQL statement object
$parameterstatus Returns the current value of a server parameter setting
$reset Resets the current connection to the database server
$transactionstatus Returns the current transaction status
$unlisten Removes the specified notification channel from the listener queue
Standard $begin $clear $coltext $commit $createnames $insertnames $logoff $logon $makeschema $nextnativeerror $rollback $rpcdefine $selectnames $updatenames$wherenames