Commands and Topics for 4D For PostgreSQL
Preface
PGSQL_Connect
(host ; port; options; tty; database; user; password)
Longint
PGSQL_Close
(connID)
PGSQL_Execute
(connID; sqlQuery)
Longint
PGSQL_GetFieldCount
(resID; fieldCount)
Longint
PGSQL_GetFieldName
(resID; fieldIndex; fieldName)
Longint
PGSQL_GetRowCount
(resID; rowCount)
Longint
PGSQL_GetFieldIndex
(resID; fieldName; fieldIndex)
Longint
PGSQL_GetFieldType
(resID; fieldIndex; fieldType)
Longint
PGSQL_GetFieldMod
(resID; fieldIndex; fieldMod)
Longint
PGSQL_GetFieldSize
(resID; fieldIndex; fieldSize)
Longint
PGSQL_IsBinaryTuples
(resID; isBinary)
Longint
PGSQL_IsFieldDataNull
(resID; rowIndex; fieldIndex; isNull)
Longint
PGSQL_GetFieldLength
(resID; rowIndex; fieldIndex; fieldLength)
Longint
PGSQL_GetStringValue
(resID; rowIndex; fieldIndex; stringValue)
Longint
PGSQL_GetIntegerValue
(resID; rowIndex; fieldIndex; integerValue)
Longint
PGSQL_GetLongintValue
(resID; rowIndex; fieldIndex; longintValue)
Longint
PGSQL_GetRealValue
(resID; rowIndex; fieldIndex; realValue)
Longint
PGSQL_GetDateValue
(resID; rowIndex; fieldIndex; dateValue)
Longint
PGSQL_GetTimeValue
(resID; rowIndex; fieldIndex; hourValue; minValue; secValue)
Longint
PGSQL_GetTextValue
(resID; rowIndex; fieldIndex; textValue)
Longint
PGSQL_GetBooleanValue
(resID; rowIndex; fieldIndex; booleanValue)
Longint
PGSQL_GetAffectedRows
(resID; affectedRows)
Longint
PGSQL_GetLastCmdStatus
(resID; lastCmdStatus)
Longint
PGSQL_GetResultStatus
(resID; resultStatus)
Longint
PGSQL_GetResultErrorMess
(resID; errorMess)
Longint
PGSQL_CloseResult
(resID)
PGSQL_ResetConn
(connID)
PGSQL_GetDbName
(connID; dbName)
Longint
PGSQL_GetUserName
(connID; userName)
Longint
PGSQL_GetPassword
(connID; password)
Longint
PGSQL_GetHostname
(connID; hostName)
Longint
PGSQL_GetPortNum
(connID; portNum)
Longint
PGSQL_GetOptions
(connID; options)
Longint
PGSQL_GetConnStatus
(connID)
Longint
PGSQL_GetLastConnError
(connID)
Longint
PGSQL_GetOIDValue
(resID; fieldIndex; rowIndex; objectValue)
Longint
PGSQL_GetByteaValue
(resID; fieldIndex; rowIndex; byteaValue)
Longint
PGSQL_EscapeBytea
(byteaToEscape; escapedBytea)
PGSQL_UnescapeBytea
(byteaToUnescape; unescapedBytea)
PGSQL_CreateLOB
(connID; mode)
Longint
PGSQL_ImportLOB
(connID; filePath; objectID)
Longint
PGSQL_ExportLOB
(connID; filePath; objectID)
Longint
PGSQL_GetLOBData
(connID; objectID; lobData)
Longint
PGSQL_SetLOBData
(connID; objectID; lobData)
Longint
PGSQL_RemoveLOB
(connID; objectID)
Longint
PGSQL_Register
(serialNum)
Longint
PGSQL_ExecuteWithBlob
(connID; blobedQuery)
Longint
PGSQL_GetValues
(resID; fieldIndex; columnArray; startRow; rowCount)