PostgreSQLSupport
classin packageklyn.databases.sql.postgresql
public class PostgreSQLSupport:
PostgreSQLSupport

PostgreSQL protocol helpers and constants.

PostgreSQL uses a message-based protocol where each message starts with a type byte followed by a 4-byte length (including itself) and then payload.

Fields
Modifier and Type Member Description
public static AUTH_CLEAR_TEXT_PASSWORD
AUTH_CLEAR_TEXT_PASSWORD as Int = 3
No summary.
public static AUTH_GSS
AUTH_GSS as Int = 7
No summary.
public static AUTH_GSS_CONTINUE
AUTH_GSS_CONTINUE as Int = 8
No summary.
public static AUTH_KERBEROS_V5
AUTH_KERBEROS_V5 as Int = 2
No summary.
public static AUTH_MD5_PASSWORD
AUTH_MD5_PASSWORD as Int = 5
No summary.
public static AUTH_OK
AUTH_OK as Int = 0
No summary.
public static AUTH_SASL
AUTH_SASL as Int = 10
No summary.
public static AUTH_SASL_CONTINUE
AUTH_SASL_CONTINUE as Int = 11
No summary.
public static AUTH_SASL_FINAL
AUTH_SASL_FINAL as Int = 12
No summary.
public static AUTH_SCM_CREDENTIAL
AUTH_SCM_CREDENTIAL as Int = 6
No summary.
public static AUTH_SSPI
AUTH_SSPI as Int = 9
No summary.
public static PROTOCOL_VERSION
PROTOCOL_VERSION as Int = 196608
No summary.
public static SSL_REQUEST_CODE
SSL_REQUEST_CODE as Int = 80877103
No summary.
public static STARTUP_MESSAGE
STARTUP_MESSAGE as Int = 196608
No summary.
Methods
Modifier and Type Member Description
public static MSG_AUTHENTICATION_REQUEST as Byte
Byte = Byte(82)
No summary.
public static MSG_BACKEND_KEY_DATA as Byte
Byte = Byte(75)
No summary.
public static MSG_BIND_COMPLETE as Byte
Byte = Byte(50)
No summary.
public static MSG_CLOSE_COMPLETE as Byte
Byte = Byte(51)
No summary.
public static MSG_COMMAND_COMPLETE as Byte
Byte = Byte(67)
No summary.
public static MSG_DATA_ROW as Byte
Byte = Byte(68)
No summary.
public static MSG_ERROR_RESPONSE as Byte
Byte = Byte(69)
No summary.
public static MSG_NO_DATA as Byte
Byte = Byte(110)
No summary.
public static MSG_PARAMETER_STATUS as Byte
Byte = Byte(83)
No summary.
public static MSG_PARSE_COMPLETE as Byte
Byte = Byte(49)
No summary.
public static MSG_PORTAL_SUSPENDED as Byte
Byte = Byte(115)
No summary.
public static MSG_READY_FOR_QUERY as Byte
Byte = Byte(90)
No summary.
public static MSG_ROW_DESCRIPTION as Byte
Byte = Byte(84)
No summary.
public static byteToChar
byteToChar(b as Byte) as String:
Converts a byte to a character string.
public static byteToHex
byteToHex(b as Byte) as String:
Converts a byte to hex string.
public static bytesToString
bytesToString(bytes as Byte[], offset as Int, length as Int) as String:
Converts bytes to string.
public static encodeUrlComponent
encodeUrlComponent(value as String) as String:
Encodes a string for use in URLs.
public static readCString
readCString(bytes as Byte[], offset as Int) as String:
Reads a null-terminated string from bytes.
public static readInt16
readInt16(bytes as Byte[], offset as Int) as Int:
Reads a 2-byte short from bytes.
public static readInt32
readInt32(bytes as Byte[], offset as Int) as Int:
Reads a 4-byte integer from bytes.
public static stringToAsciiBytes
stringToAsciiBytes(value as String) as Byte[]:
Converts a string to ASCII bytes.
public static writeCString
writeCString(builder as PostgreSQLByteBuilder, value as String) as Void:
Writes a null-terminated string to bytes.
public static writeInt16
writeInt16(builder as PostgreSQLByteBuilder, value as Int) as Void:
Writes a 2-byte short.
public static writeInt32
writeInt32(builder as PostgreSQLByteBuilder, value as Int) as Void:
Writes a 4-byte integer.