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	-185541640502400000L
public static final long	DATE_POSITIVE_INFINITY	9223372036825200000L
public static final long	DATE_POSITIVE_SMALLER_INFINITY	185541640502400000L

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.v3.replication.V3PGReplicationStream

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

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.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.util.DriverInfo

Modifier and Type	Constant Field	Value
public static final java.lang.String	DRIVER_FULL_NAME	"PostgreSQL JDBC Driver 42.7.9"
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.9"
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	9

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]"