Constant Field Values

Contents

• org.postgresql.*

org.postgresql.*

org.postgresql.PGStatement

Modifier and Type	Constant Field	Value
public static final long	DATE_NEGATIVE_INFINITY	-9223372036832400000L
public static final long	DATE_NEGATIVE_SMALLER_INFINITY	-185543533774800000L
public static final long	DATE_POSITIVE_INFINITY	9223372036825200000L
public static final long	DATE_POSITIVE_SMALLER_INFINITY	185543533774800000L

org.postgresql.copy.CopyManager

Modifier and Type	Constant Field	Value
static final int	DEFAULT_BUFFER_SIZE	65536

org.postgresql.core.Field

Modifier and Type	Constant Field	Value
public static final int	BINARY_FORMAT	1
public static final int	TEXT_FORMAT	0

org.postgresql.core.Oid

Modifier and Type	Constant Field	Value
public static final int	BIT	1560
public static final int	BIT_ARRAY	1561
public static final int	BOOL	16
public static final int	BOOL_ARRAY	1000
public static final int	BOX	603
public static final int	BOX_ARRAY	1020
public static final int	BPCHAR	1042
public static final int	BPCHAR_ARRAY	1014
public static final int	BYTEA	17
public static final int	BYTEA_ARRAY	1001
public static final int	CHAR	18
public static final int	CHAR_ARRAY	1002
public static final int	CIDR	650
public static final int	CIRCLE	718
public static final int	DATE	1082
public static final int	DATE_ARRAY	1182
public static final int	FLOAT4	700
public static final int	FLOAT4_ARRAY	1021
public static final int	FLOAT8	701
public static final int	FLOAT8_ARRAY	1022
public static final int	INET	869
public static final int	INT2	21
public static final int	INT2_ARRAY	1005
public static final int	INT4	23
public static final int	INT4_ARRAY	1007
public static final int	INT8	20
public static final int	INT8_ARRAY	1016
public static final int	INTERVAL	1186
public static final int	INTERVAL_ARRAY	1187
public static final int	JSON	114
public static final int	JSON_ARRAY	199
public static final int	JSONB	3802
public static final int	JSONB_ARRAY	3807
public static final int	LINE	628
public static final int	LSEG	601
public static final int	MACADDR	829
public static final int	MACADDR8	774
public static final int	MONEY	790
public static final int	MONEY_ARRAY	791
public static final int	NAME	19
public static final int	NAME_ARRAY	1003
public static final int	NUMERIC	1700
public static final int	NUMERIC_ARRAY	1231
public static final int	OID	26
public static final int	OID_ARRAY	1028
public static final int	PATH	602
public static final int	POINT	600
public static final int	POINT_ARRAY	1017
public static final int	POLYGON	604
public static final int	REF_CURSOR	1790
public static final int	REF_CURSOR_ARRAY	2201
public static final int	TEXT	25
public static final int	TEXT_ARRAY	1009
public static final int	TIME	1083
public static final int	TIME_ARRAY	1183
public static final int	TIMESTAMP	1114
public static final int	TIMESTAMP_ARRAY	1115
public static final int	TIMESTAMPTZ	1184
public static final int	TIMESTAMPTZ_ARRAY	1185
public static final int	TIMETZ	1266
public static final int	TIMETZ_ARRAY	1270
public static final int	TSQUERY	3615
public static final int	TSVECTOR	3614
public static final int	UNSPECIFIED	0
public static final int	UUID	2950
public static final int	UUID_ARRAY	2951
public static final int	VARBIT	1562
public static final int	VARBIT_ARRAY	1563
public static final int	VARCHAR	1043
public static final int	VARCHAR_ARRAY	1015
public static final int	VOID	2278
public static final int	XML	142
public static final int	XML_ARRAY	143

org.postgresql.core.PgMessageType

Modifier and Type	Constant Field	Value
public static final byte	ASYNCHRONOUS_NOTICE	65
public static final byte	AUTHENTICATION_RESPONSE	82
public static final byte	BACKEND_KEY_DATA_RESPONSE	75
public static final byte	BIND	66
public static final byte	BIND_COMPLETE_RESPONSE	50
public static final byte	CLOSE_COMPLETE_RESPONSE	51
public static final byte	CLOSE_REQUEST	67
public static final byte	COMMAND_COMPLETE_RESPONSE	67
public static final byte	COPY_BOTH_RESPONSE	87
public static final byte	COPY_DATA	100
public static final byte	COPY_DONE	99
public static final byte	COPY_FAIL	102
public static final byte	COPY_IN_RESPONSE	71
public static final byte	COPY_OUT_RESPONSE	72
public static final byte	DATA_ROW_RESPONSE	68
public static final byte	DESCRIBE_REQUEST	68
public static final byte	EMPTY_QUERY_RESPONSE	73
public static final byte	ERROR_RESPONSE	69
public static final byte	EXECUTE_REQUEST	69
public static final byte	FLUSH_REQ	72
public static final byte	FUNCTION_CALL_REQ	70
public static final byte	FUNCTION_CALL_RESPONSE	86
public static final byte	GSS_TOKEN_REQUEST	112
public static final byte	NEGOTIATE_PROTOCOL_RESPONSE	118
public static final byte	NO_DATA_RESPONSE	110
public static final byte	NOTICE_RESPONSE	78
public static final byte	PARAMETER_DESCRIPTION_RESPONSE	116
public static final byte	PARAMETER_STATUS_RESPONSE	83
public static final byte	PARSE_COMPLETE_RESPONSE	49
public static final byte	PARSE_REQUEST	80
public static final byte	PASSWORD_REQUEST	112
public static final byte	PORTAL	80
public static final byte	PORTAL_SUSPENDED_RESPONSE	115
public static final byte	QUERY_REQUEST	81
public static final byte	READY_FOR_QUERY_RESPONSE	90
public static final byte	ROW_DESCRIPTION_RESPONSE	84
public static final byte	SASL_INITIAL_RESPONSE	112
public static final byte	SASL_RESPONSE	112
public static final byte	STATEMENT	83
public static final byte	SYNC_REQUEST	83
public static final byte	TERMINATE_REQUEST	88

org.postgresql.core.QueryExecutor

Modifier and Type	Constant Field	Value
public static final int	MAX_SAVE_POINTS	1000
public static final int	QUERY_BOTH_ROWS_AND_STATUS	64
public static final int	QUERY_DESCRIBE_ONLY	32
public static final int	QUERY_DISALLOW_BATCHING	128
public static final int	QUERY_EXECUTE_AS_SIMPLE	1024
public static final int	QUERY_FORCE_DESCRIBE_PORTAL	512
public static final int	QUERY_FORWARD_CURSOR	8
public static final int	QUERY_NO_BINARY_TRANSFER	256
public static final int	QUERY_NO_METADATA	2
public static final int	QUERY_NO_RESULTS	4
public static final int	QUERY_ONESHOT	1
public static final int	QUERY_READ_ONLY_HINT	2048
public static final int	QUERY_SUPPRESS_BEGIN	16

org.postgresql.core.VisibleBufferedInputStream

Modifier and Type	Constant Field	Value
private static final int	MINIMUM_READ	1024
private static final int	STRING_SCAN_SPAN	1024

org.postgresql.core.v3.ConnectionFactoryImpl

Modifier and Type	Constant Field	Value
private static final int	AUTH_REQ_CRYPT	4
private static final int	AUTH_REQ_GSS	7
private static final int	AUTH_REQ_GSS_CONTINUE	8
private static final int	AUTH_REQ_KRB4	1
private static final int	AUTH_REQ_KRB5	2
private static final int	AUTH_REQ_MD5	5
private static final int	AUTH_REQ_OK	0
private static final int	AUTH_REQ_PASSWORD	3
private static final int	AUTH_REQ_SASL	10
private static final int	AUTH_REQ_SASL_CONTINUE	11
private static final int	AUTH_REQ_SASL_FINAL	12
private static final int	AUTH_REQ_SCM	6
private static final int	AUTH_REQ_SSPI	9
private static final java.lang.String	IN_HOT_STANDBY	"in_hot_standby"

org.postgresql.core.v3.QueryExecutorImpl

Modifier and Type	Constant Field	Value
private static final int	MAX_BUFFERED_RECV_BYTES	64000
private static final int	NODATA_QUERY_RESPONSE_SIZE_BYTES	250

org.postgresql.core.v3.org.postgresql.core.v3.SimpleParameterList

Modifier and Type	Constant Field	Value
private static final byte	BINARY	4
private static final byte	IN	1
private static final byte	INOUT	3
private static final byte	OUT	2
private static final byte	TEXT	0

org.postgresql.core.v3.replication.V3PGReplicationStream

Modifier and Type	Constant Field	Value
private static final long	NANOS_PER_MILLISECOND	1000000L
public static final long	POSTGRES_EPOCH_2000_01_01	946684800000L

org.postgresql.fastpath.Fastpath

Modifier and Type	Constant Field	Value
private static final long	NUM_OIDS	4294967296L

org.postgresql.jdbc.org.postgresql.jdbc.AbstractBlobClob.LOIterator

Modifier and Type	Constant Field	Value
private static final int	BUFFER_SIZE	8096

org.postgresql.jdbc.org.postgresql.jdbc.ArrayDecoding.PgArrayList

Modifier and Type	Constant Field	Value
private static final long	serialVersionUID	1L

org.postgresql.jdbc.EscapedFunctions

Modifier and Type	Constant Field	Value
public static final java.lang.String	ABS	"abs"
public static final java.lang.String	ACOS	"acos"
public static final java.lang.String	ASCII	"ascii"
public static final java.lang.String	ASIN	"asin"
public static final java.lang.String	ATAN	"atan"
public static final java.lang.String	ATAN2	"atan2"
public static final java.lang.String	CEILING	"ceiling"
public static final java.lang.String	CHAR	"char"
public static final java.lang.String	CONCAT	"concat"
public static final java.lang.String	COS	"cos"
public static final java.lang.String	COT	"cot"
public static final java.lang.String	CURDATE	"curdate"
public static final java.lang.String	CURTIME	"curtime"
public static final java.lang.String	DATABASE	"database"
public static final java.lang.String	DAYNAME	"dayname"
public static final java.lang.String	DAYOFMONTH	"dayofmonth"
public static final java.lang.String	DAYOFWEEK	"dayofweek"
public static final java.lang.String	DAYOFYEAR	"dayofyear"
public static final java.lang.String	DEGREES	"degrees"
public static final java.lang.String	EXP	"exp"
public static final java.lang.String	FLOOR	"floor"
public static final java.lang.String	HOUR	"hour"
public static final java.lang.String	IFNULL	"ifnull"
public static final java.lang.String	INSERT	"insert"
public static final java.lang.String	LCASE	"lcase"
public static final java.lang.String	LEFT	"left"
public static final java.lang.String	LENGTH	"length"
public static final java.lang.String	LOCATE	"locate"
public static final java.lang.String	LOG	"log"
public static final java.lang.String	LOG10	"log10"
public static final java.lang.String	LTRIM	"ltrim"
public static final java.lang.String	MINUTE	"minute"
public static final java.lang.String	MOD	"mod"
public static final java.lang.String	MONTH	"month"
public static final java.lang.String	MONTHNAME	"monthname"
public static final java.lang.String	NOW	"now"
public static final java.lang.String	PI	"pi"
public static final java.lang.String	POWER	"power"
public static final java.lang.String	QUARTER	"quarter"
public static final java.lang.String	RADIANS	"radians"
public static final java.lang.String	REPEAT	"repeat"
public static final java.lang.String	REPLACE	"replace"
public static final java.lang.String	RIGHT	"right"
public static final java.lang.String	ROUND	"round"
public static final java.lang.String	RTRIM	"rtrim"
public static final java.lang.String	SECOND	"second"
public static final java.lang.String	SIGN	"sign"
public static final java.lang.String	SIN	"sin"
public static final java.lang.String	SPACE	"space"
public static final java.lang.String	SQL_TSI_DAY	"DAY"
public static final java.lang.String	SQL_TSI_FRAC_SECOND	"FRAC_SECOND"
public static final java.lang.String	SQL_TSI_HOUR	"HOUR"
public static final java.lang.String	SQL_TSI_MINUTE	"MINUTE"
public static final java.lang.String	SQL_TSI_MONTH	"MONTH"
public static final java.lang.String	SQL_TSI_QUARTER	"QUARTER"
public static final java.lang.String	SQL_TSI_ROOT	"SQL_TSI_"
public static final java.lang.String	SQL_TSI_SECOND	"SECOND"
public static final java.lang.String	SQL_TSI_WEEK	"WEEK"
public static final java.lang.String	SQL_TSI_YEAR	"YEAR"
public static final java.lang.String	SQRT	"sqrt"
public static final java.lang.String	SUBSTRING	"substring"
public static final java.lang.String	TAN	"tan"
public static final java.lang.String	TIMESTAMPADD	"timestampadd"
public static final java.lang.String	TIMESTAMPDIFF	"timestampdiff"
public static final java.lang.String	TRUNCATE	"truncate"
public static final java.lang.String	UCASE	"ucase"
public static final java.lang.String	USER	"user"
public static final java.lang.String	WEEK	"week"
public static final java.lang.String	YEAR	"year"

org.postgresql.jdbc.EscapedFunctions2

Modifier and Type	Constant Field	Value
private static final java.lang.String	SQL_TSI_DAY	"SQL_TSI_DAY"
private static final java.lang.String	SQL_TSI_FRAC_SECOND	"SQL_TSI_FRAC_SECOND"
private static final java.lang.String	SQL_TSI_HOUR	"SQL_TSI_HOUR"
private static final java.lang.String	SQL_TSI_MINUTE	"SQL_TSI_MINUTE"
private static final java.lang.String	SQL_TSI_MONTH	"SQL_TSI_MONTH"
private static final java.lang.String	SQL_TSI_QUARTER	"SQL_TSI_QUARTER"
private static final java.lang.String	SQL_TSI_ROOT	"SQL_TSI_"
private static final java.lang.String	SQL_TSI_SECOND	"SQL_TSI_SECOND"
private static final java.lang.String	SQL_TSI_WEEK	"SQL_TSI_WEEK"
private static final java.lang.String	SQL_TSI_YEAR	"SQL_TSI_YEAR"

org.postgresql.jdbc.TimestampUtils

Modifier and Type	Constant Field	Value
private static final int	MAX_NANOS_BEFORE_WRAP_ON_ROUND	999999500
private static final int	ONEDAY	86400000

org.postgresql.jdbcurlresolver.PgPassParser

Modifier and Type	Constant Field	Value
private static final char	SEPARATOR	58

org.postgresql.largeobject.BlobInputStream

Modifier and Type	Constant Field	Value
static final int	DEFAULT_MAX_BUFFER_SIZE	524288
static final int	INITIAL_BUFFER_SIZE	65536

org.postgresql.largeobject.BlobOutputStream

Modifier and Type	Constant Field	Value
static final int	DEFAULT_MAX_BUFFER_SIZE	524288

org.postgresql.largeobject.LargeObject

Modifier and Type	Constant Field	Value
public static final int	SEEK_CUR	1
public static final int	SEEK_END	2
public static final int	SEEK_SET	0

org.postgresql.largeobject.LargeObjectManager

Modifier and Type	Constant Field	Value
public static final int	READ	262144
public static final int	READWRITE	393216
public static final int	WRITE	131072

org.postgresql.ssl.PGjdbcHostnameVerifier

Modifier and Type	Constant Field	Value
private static final int	TYPE_DNS_NAME	2
private static final int	TYPE_IP_ADDRESS	7

org.postgresql.ssl.SingleCertValidatingFactory

Modifier and Type	Constant Field	Value
private static final java.lang.String	CLASSPATH_PREFIX	"classpath:"
private static final java.lang.String	ENV_PREFIX	"env:"
private static final java.lang.String	FILE_PREFIX	"file:"
private static final java.lang.String	SYS_PROP_PREFIX	"sys:"

org.postgresql.util.ByteConverter

Modifier and Type	Constant Field	Value
private static final int	LONG_BYTES	4
private static final int	NUMERIC_DSCALE_MASK	16383
private static final short	NUMERIC_NAN	-16384
private static final short	NUMERIC_NEG	16384
private static final short	NUMERIC_NINF	-4096
private static final short	NUMERIC_PINF	-12288
private static final short	NUMERIC_POS	0
private static final int	SHORT_BYTES	2

org.postgresql.util.DriverInfo

Modifier and Type	Constant Field	Value
public static final java.lang.String	DRIVER_FULL_NAME	"PostgreSQL JDBC Driver 42.7.7"
public static final java.lang.String	DRIVER_NAME	"PostgreSQL JDBC Driver"
public static final java.lang.String	DRIVER_SHORT_NAME	"PgJDBC"
public static final java.lang.String	DRIVER_VERSION	"42.7.7"
public static final java.lang.String	JDBC_VERSION	"4.2"
public static final int	MAJOR_VERSION	42
public static final int	MINOR_VERSION	7
public static final int	PATCH_VERSION	7

org.postgresql.util.HostSpec

Modifier and Type	Constant Field	Value
public static final java.lang.String	DEFAULT_NON_PROXY_HOSTS	"localhost|127.*|[::1]|0.0.0.0|[::0]"

org.postgresql.util.KerberosTicket

Modifier and Type	Constant Field	Value
private static final java.lang.String	CONFIG_ITEM_NAME	"ticketCache"
private static final java.lang.String	KRBLOGIN_MODULE	"com.sun.security.auth.module.Krb5LoginModule"

org.postgresql.util.NumberParser

Modifier and Type	Constant Field	Value
private static final long	MAX_LONG_DIV_TEN	922337203685477580L

org.postgresql.util.PasswordUtil

Modifier and Type	Constant Field	Value
private static final int	DEFAULT_ITERATIONS	4096
private static final int	DEFAULT_SALT_LENGTH	16

org.postgresql.util.PGbytea

Modifier and Type	Constant Field	Value
private static final int	MAX_3_BUFF_SIZE	2097152

org.postgresql.util.PGInterval

Modifier and Type	Constant Field	Value
private static final int	MICROS_IN_SECOND	1000000

org.postgresql.util.PGTime

Modifier and Type	Constant Field	Value
private static final long	serialVersionUID	3592492258676494276L

org.postgresql.util.PGTimestamp

Modifier and Type	Constant Field	Value
private static final long	serialVersionUID	-6245623465210738466L

org.postgresql.util.ReaderInputStream

Modifier and Type	Constant Field	Value
private static final int	DEFAULT_CHAR_BUFFER_SIZE	8192

org.postgresql.util.StreamWrapper

Modifier and Type	Constant Field	Value
private static final int	MAX_MEMORY_BUFFER_BYTES	51200
private static final java.lang.String	TEMP_FILE_PREFIX	"postgres-pgjdbc-stream"

org.postgresql.util.internal.IntSet

Modifier and Type	Constant Field	Value
private static final int	MAX_OID_TO_STORE_IN_BITSET	65536