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	MSG_AUTHENTICATION_REQUEST `MSG_AUTHENTICATION_REQUEST as Byte = Byte(82)`	No summary.
public static	MSG_BACKEND_KEY_DATA `MSG_BACKEND_KEY_DATA as Byte = Byte(75)`	No summary.
public static	MSG_BIND_COMPLETE `MSG_BIND_COMPLETE as Byte = Byte(50)`	No summary.
public static	MSG_CLOSE_COMPLETE `MSG_CLOSE_COMPLETE as Byte = Byte(51)`	No summary.
public static	MSG_COMMAND_COMPLETE `MSG_COMMAND_COMPLETE as Byte = Byte(67)`	No summary.
public static	MSG_DATA_ROW `MSG_DATA_ROW as Byte = Byte(68)`	No summary.
public static	MSG_ERROR_RESPONSE `MSG_ERROR_RESPONSE as Byte = Byte(69)`	No summary.
public static	MSG_NO_DATA `MSG_NO_DATA as Byte = Byte(110)`	No summary.
public static	MSG_PARAMETER_STATUS `MSG_PARAMETER_STATUS as Byte = Byte(83)`	No summary.
public static	MSG_PARSE_COMPLETE `MSG_PARSE_COMPLETE as Byte = Byte(49)`	No summary.
public static	MSG_PORTAL_SUSPENDED `MSG_PORTAL_SUSPENDED as Byte = Byte(115)`	No summary.
public static	MSG_READY_FOR_QUERY `MSG_READY_FOR_QUERY as Byte = Byte(90)`	No summary.
public static	MSG_ROW_DESCRIPTION `MSG_ROW_DESCRIPTION as Byte = Byte(84)`	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	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`	Decodes a bounded UTF-8 protocol field without replacing non-ASCII text.
public static	decodeBytea `decodeBytea(raw as String) as Byte[]`	Decodes PostgreSQL bytea text in hex or legacy escaped-octal format.
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[]`	Encodes protocol text in UTF-8 (the historical method name is retained).
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.