A B C D E F G H I J K L M N O P Q R S T U V W X Y _

A

a - Variable in class org.postgresql.geometric.PGline

Coefficient of x

abort() - Method in interface org.postgresql.core.QueryExecutor

Abort at network level without sending the Terminate message to the backend.

abort() - Method in class org.postgresql.core.QueryExecutorBase

abort() - Method in class org.postgresql.jdbc.PgConnection

abort(Executor) - Method in class org.postgresql.jdbc.PgConnection

ABS - Static variable in class org.postgresql.jdbc.EscapedFunctions

absolute(int) - Method in class org.postgresql.jdbc.PgResultSet

AbstractBlobClob - Class in org.postgresql.jdbc

This class holds all of the methods common to both Blobs and Clobs.

AbstractBlobClob(BaseConnection, long) - Constructor for class org.postgresql.jdbc.AbstractBlobClob

acceptsURL(String) - Method in class org.postgresql.Driver

Returns true if the driver thinks it can open a connection to the given URL.

ACOS - Static variable in class org.postgresql.jdbc.EscapedFunctions

ACTIVE_SQL_TRANSACTION - Static variable in class org.postgresql.util.PSQLState

add(Calendar) - Method in class org.postgresql.util.PGInterval

Rolls this interval on a given calendar

add(Date) - Method in class org.postgresql.util.PGInterval

Rolls this interval on a given date

add(PGInterval) - Method in class org.postgresql.util.PGInterval

Add this interval's value to the passed interval.

addBatch(String) - Method in class org.postgresql.jdbc.PgStatement

addConnectionEventListener(ConnectionEventListener) - Method in class org.postgresql.ds.PGPooledConnection

Adds a listener for close or fatal error events on the connection handed out to a client.

addCoreType(String, Integer, Integer, String, Integer) - Method in interface org.postgresql.core.TypeInfo

addCoreType(String, Integer, Integer, String, Integer) - Method in class org.postgresql.jdbc.TypeInfoCache

addDataSource(String) - Method in class org.postgresql.ds.PGPoolingDataSource

addDataType(String, Class<? extends PGobject>) - Method in interface org.postgresql.core.TypeInfo

addDataType(String, String) - Method in class org.postgresql.jdbc.PgConnection

addDataType(String, Class<? extends PGobject>) - Method in class org.postgresql.jdbc.PgConnection

addDataType(String, Class<? extends PGobject>) - Method in class org.postgresql.jdbc.TypeInfoCache

addDataType(String, String) - Method in interface org.postgresql.PGConnection

Deprecated. As of 8.0, replaced by PGConnection.addDataType(String, Class). This deprecated method does not work correctly for registering classes that cannot be directly loaded by the JDBC driver's classloader.

addDataType(String, Class<? extends PGobject>) - Method in interface org.postgresql.PGConnection

This allows client code to add a handler for one of org.postgresql's more unique data types.

addFunction(String, int) - Method in class org.postgresql.fastpath.Fastpath

This adds a function to our lookup table.

addFunctions(ResultSet) - Method in class org.postgresql.fastpath.Fastpath

This takes a ResultSet containing two columns.

addNotification(PGNotification) - Method in class org.postgresql.core.QueryExecutorBase

addStatementEventListener(StatementEventListener) - Method in class org.postgresql.ds.PGPooledConnection

addSubLO(LargeObject) - Method in class org.postgresql.jdbc.AbstractBlobClob

addTimerTask(TimerTask, long) - Method in interface org.postgresql.core.BaseConnection

Schedule a TimerTask for later execution.

addTimerTask(TimerTask, long) - Method in class org.postgresql.jdbc.PgConnection

addWarning(SQLWarning) - Method in class org.postgresql.core.QueryExecutorBase

addWarning(SQLWarning) - Method in class org.postgresql.jdbc.PgConnection

This adds a warning to the warning chain.

addWarning(SQLWarning) - Method in class org.postgresql.jdbc.PgResultSet

addWarning(SQLWarning) - Method in class org.postgresql.jdbc.PgStatement

This adds a warning to the warning chain.

afterLast() - Method in class org.postgresql.jdbc.PgResultSet

allowConnectingTo(HostStatus) - Method in enum org.postgresql.hostchooser.HostRequirement

allProceduresAreCallable() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

allTablesAreSelectable() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

append(ResultWrapper) - Method in class org.postgresql.jdbc.ResultWrapper

appendAll(ParameterList) - Method in interface org.postgresql.core.ParameterList

Use this operation to append more parameters to the current list.

appendBindName(StringBuilder, int) - Static method in class org.postgresql.core.NativeQuery

appendEscapedIdentifier(StringBuffer, String) - Static method in class org.postgresql.core.Utils

Deprecated. use Utils.escapeIdentifier(StringBuilder, String) instead

appendEscapedLiteral(StringBuffer, String, boolean) - Static method in class org.postgresql.core.Utils

Deprecated. use Utils.escapeLiteral(StringBuilder, String, boolean) instead

ArrayAssistant - Interface in org.postgresql.jdbc2

Implement this interface and register the its instance to ArrayAssistantRegistry, to let Postgres driver to support more array type

ArrayAssistantRegistry - Class in org.postgresql.jdbc2

Array assistants register here

ArrayAssistantRegistry() - Constructor for class org.postgresql.jdbc2.ArrayAssistantRegistry

arrayList - Variable in class org.postgresql.jdbc.PgArray

Value of field as PgArrayList.

ASCII - Static variable in class org.postgresql.jdbc.EscapedFunctions

ASIN - Static variable in class org.postgresql.jdbc.EscapedFunctions

asLowerCase() - Method in enum org.postgresql.core.Keyword

assertPosition(long) - Method in class org.postgresql.jdbc.AbstractBlobClob

Throws an exception if the pos value exceeds the max value by which the large object API can index.

assertPosition(long, long) - Method in class org.postgresql.jdbc.AbstractBlobClob

Throws an exception if the pos value exceeds the max value by which the large object API can index.

ATAN - Static variable in class org.postgresql.jdbc.EscapedFunctions

ATAN2 - Static variable in class org.postgresql.jdbc.EscapedFunctions

authenticate(PGStream, String, String, String, String, String, Logger, boolean) - Static method in class org.postgresql.gss.MakeGSS

autoCommitFailureClosesAllResultSets() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

AutoSave - Enum in org.postgresql.jdbc

available() - Method in class org.postgresql.copy.PGCopyInputStream

available() - Method in class org.postgresql.core.VisibleBufferedInputStream

B

b - Variable in class org.postgresql.geometric.PGline

Coefficient of y

BAD_DATETIME_FORMAT - Static variable in class org.postgresql.util.PSQLState

Base64 - Class in org.postgresql.util

This code is a stripped down version of Robert Harder's Public Domain Base64 implementation.

BaseConnection - Interface in org.postgresql.core

Driver-internal connection interface.

BaseDataSource - Class in org.postgresql.ds.common

Base class for data sources and related classes.

BaseDataSource() - Constructor for class org.postgresql.ds.common.BaseDataSource

BaseStatement - Interface in org.postgresql.core

Driver-internal statement interface.

baseType() - Method in class org.postgresql.jdbc.UUIDArrayAssistant

baseType() - Method in interface org.postgresql.jdbc2.ArrayAssistant

get array base type

BatchedQuery - Class in org.postgresql.core.v3

Purpose of this object is to support batched query re write behaviour.

BatchedQuery(NativeQuery, TypeTransferModeRegistry, int, int, boolean) - Constructor for class org.postgresql.core.v3.BatchedQuery

batchParameters - Variable in class org.postgresql.jdbc.PgStatement

BatchResultHandler - Class in org.postgresql.jdbc

Internal class, it is not a part of public API.

batchStatements - Variable in class org.postgresql.jdbc.PgStatement

beforeFirst() - Method in class org.postgresql.jdbc.PgResultSet

BINARY_FORMAT - Static variable in class org.postgresql.core.Field

binaryTransferSend(int) - Method in interface org.postgresql.core.BaseConnection

Returns true if value for the given oid should be sent using binary transfer.

binaryTransferSend(int) - Method in class org.postgresql.jdbc.PgConnection

bindName(int) - Static method in class org.postgresql.core.NativeQuery

Returns $1, $2, etc names of bind variables used by backend.

bindPositions - Variable in class org.postgresql.core.NativeQuery

BIT - Static variable in class org.postgresql.core.Oid

BIT_ARRAY - Static variable in class org.postgresql.core.Oid

BLANK - Static variable in class org.postgresql.core.SqlCommand

BlobInputStream - Class in org.postgresql.largeobject

This is an implementation of an InputStream from a large object.

BlobInputStream(LargeObject) - Constructor for class org.postgresql.largeobject.BlobInputStream

BlobInputStream(LargeObject, int) - Constructor for class org.postgresql.largeobject.BlobInputStream

BlobInputStream(LargeObject, int, long) - Constructor for class org.postgresql.largeobject.BlobInputStream

BlobOutputStream - Class in org.postgresql.largeobject

This implements a basic output stream that writes to a LargeObject

BlobOutputStream(LargeObject) - Constructor for class org.postgresql.largeobject.BlobOutputStream

Create an OutputStream to a large object

BlobOutputStream(LargeObject, int) - Constructor for class org.postgresql.largeobject.BlobOutputStream

Create an OutputStream to a large object

BOOL - Static variable in class org.postgresql.core.Oid

BOOL_ARRAY - Static variable in class org.postgresql.core.Oid

borrow(Key) - Method in class org.postgresql.util.LruCache

Borrows an entry from the cache.

borrowCallableQuery(String) - Method in interface org.postgresql.core.QueryExecutor

borrowCallableQuery(String) - Method in class org.postgresql.core.QueryExecutorBase

borrowQuery(String) - Method in interface org.postgresql.core.QueryExecutor

borrowQuery(String) - Method in class org.postgresql.core.QueryExecutorBase

borrowQueryByKey(Object) - Method in interface org.postgresql.core.QueryExecutor

borrowQueryByKey(Object) - Method in class org.postgresql.core.QueryExecutorBase

borrowReturningQuery(String, String[]) - Method in interface org.postgresql.core.QueryExecutor

borrowReturningQuery(String, String[]) - Method in class org.postgresql.core.QueryExecutorBase

BOX - Static variable in class org.postgresql.core.Oid

BPCHAR - Static variable in class org.postgresql.core.Oid

BPCHAR_ARRAY - Static variable in class org.postgresql.core.Oid

buildElement(byte[], int, int) - Method in class org.postgresql.jdbc.UUIDArrayAssistant

buildElement(String) - Method in class org.postgresql.jdbc.UUIDArrayAssistant

buildElement(byte[], int, int) - Method in interface org.postgresql.jdbc2.ArrayAssistant

build a array element from its binary bytes

buildElement(String) - Method in interface org.postgresql.jdbc2.ArrayAssistant

build an array element from its literal string

BYTEA - Static variable in class org.postgresql.core.Oid

BYTEA_ARRAY - Static variable in class org.postgresql.core.Oid

ByteConverter - Class in org.postgresql.util

Helper methods to parse java base types from byte arrays.

C

c - Variable in class org.postgresql.geometric.PGline

Constant

CachedQuery - Class in org.postgresql.core

Stores information on the parsed JDBC query.

CachedQuery(Object, Query, boolean, boolean) - Constructor for class org.postgresql.core.CachedQuery

calculateBindLength(int) - Static method in class org.postgresql.core.NativeQuery

Calculate the text length required for the given number of bind variables including dollars.

cancel() - Method in class org.postgresql.jdbc.PgStatement

cancelCopy() - Method in interface org.postgresql.copy.CopyOperation

Cancels this copy operation, discarding any exchanged data.

cancelCopy() - Method in class org.postgresql.copy.PGCopyInputStream

cancelCopy() - Method in class org.postgresql.copy.PGCopyOutputStream

cancelCopy() - Method in class org.postgresql.core.v3.CopyOperationImpl

cancelCopy(CopyOperationImpl) - Method in class org.postgresql.core.v3.QueryExecutorImpl

Finishes a copy operation and unlocks connection discarding any exchanged data.

cancelQuery() - Method in interface org.postgresql.core.BaseConnection

Cancel the current query executing on this connection.

cancelQuery() - Method in class org.postgresql.jdbc.PgConnection

cancelRowUpdates() - Method in class org.postgresql.jdbc.PgResultSet

CanEstimateSize - Interface in org.postgresql.util

CEILING - Static variable in class org.postgresql.jdbc.EscapedFunctions

center - Variable in class org.postgresql.geometric.PGcircle

This is the center point

changeSocket(Socket) - Method in class org.postgresql.core.PGStream

Switch this stream to using a new socket.

CHAR - Static variable in class org.postgresql.core.Oid

CHAR - Static variable in class org.postgresql.jdbc.EscapedFunctions

CHAR_ARRAY - Static variable in class org.postgresql.core.Oid

charTerminatesIdentifier(char) - Static method in class org.postgresql.core.Parser

checkClientTrusted(X509Certificate[], String) - Method in class org.postgresql.ssl.NonValidatingFactory.NonValidatingTM

checkClientTrusted(X509Certificate[], String) - Method in class org.postgresql.ssl.SingleCertValidatingFactory.SingleCertTrustManager

checkClosed() - Method in class org.postgresql.jdbc.PgConnection

checkClosed() - Method in class org.postgresql.jdbc.PgResultSet

checkClosed() - Method in class org.postgresql.jdbc.PgStatement

checkColumnIndex(int) - Method in class org.postgresql.jdbc.PgResultSet

checkCompletion() - Method in class org.postgresql.jdbc.PgStatement

checkFreed() - Method in class org.postgresql.jdbc.AbstractBlobClob

Checks that this LOB hasn't been free()d already.

checkResultSet(int) - Method in class org.postgresql.jdbc.PgResultSet

Checks that the result set is not closed, it's positioned on a valid row and that the given column number is valid.

checkServerTrusted(X509Certificate[], String) - Method in class org.postgresql.ssl.NonValidatingFactory.NonValidatingTM

checkServerTrusted(X509Certificate[], String) - Method in class org.postgresql.ssl.SingleCertValidatingFactory.SingleCertTrustManager

chooseClientAlias(String[], Principal[], Socket) - Method in class org.postgresql.ssl.jdbc4.LazyKeyManager

chooseServerAlias(String, Principal[], Socket) - Method in class org.postgresql.ssl.jdbc4.LazyKeyManager

clear() - Method in interface org.postgresql.core.ParameterList

Unbind all parameter values bound in this list.

clearBatch() - Method in class org.postgresql.jdbc.PgStatement

clearWarnings() - Method in class org.postgresql.jdbc.PgConnection

clearWarnings() - Method in class org.postgresql.jdbc.PgResultSet

clearWarnings() - Method in class org.postgresql.jdbc.PgStatement

clone() - Method in class org.postgresql.geometric.PGbox

clone() - Method in class org.postgresql.geometric.PGcircle

clone() - Method in class org.postgresql.geometric.PGline

clone() - Method in class org.postgresql.geometric.PGlseg

clone() - Method in class org.postgresql.geometric.PGpath

clone() - Method in class org.postgresql.geometric.PGpoint

clone() - Method in class org.postgresql.geometric.PGpolygon

clone() - Method in class org.postgresql.util.PGInterval

clone() - Method in class org.postgresql.util.PGmoney

clone() - Method in class org.postgresql.util.PGobject

This must be overidden to allow the object to be cloned

clone() - Method in class org.postgresql.util.PGTime

clone() - Method in class org.postgresql.util.PGTimestamp

close() - Method in class org.postgresql.copy.PGCopyInputStream

close() - Method in class org.postgresql.copy.PGCopyOutputStream

close() - Method in class org.postgresql.core.PGStream

Closes the connection

close() - Method in interface org.postgresql.core.Query

Close this query and free any server-side resources associated with it.

close() - Method in interface org.postgresql.core.QueryExecutor

Close this connection cleanly.

close() - Method in class org.postgresql.core.QueryExecutorBase

close() - Method in interface org.postgresql.core.ResultCursor

Close this cursor.

close() - Method in class org.postgresql.core.VisibleBufferedInputStream

close() - Method in class org.postgresql.ds.PGPooledConnection

Closes the physical database connection represented by this PooledConnection.

close() - Method in class org.postgresql.ds.PGPoolingDataSource

Closes this DataSource, and all the pooled connections, whether in use or not.

close() - Method in class org.postgresql.jdbc.PgConnection

Note: even though Statement is automatically closed when it is garbage collected, it is better to close it explicitly to lower resource consumption.

close() - Method in class org.postgresql.jdbc.PgResultSet

close() - Method in class org.postgresql.jdbc.PgStatement

Note: even though Statement is automatically closed when it is garbage collected, it is better to close it explicitly to lower resource consumption.

close() - Method in class org.postgresql.largeobject.BlobInputStream

Closes this input stream and releases any system resources associated with the stream.

close() - Method in class org.postgresql.largeobject.BlobOutputStream

close() - Method in class org.postgresql.largeobject.LargeObject

This method closes the object.

close(Connection) - Static method in class org.postgresql.util.JdbcBlackHole

close(Statement) - Static method in class org.postgresql.util.JdbcBlackHole

close(ResultSet) - Static method in class org.postgresql.util.JdbcBlackHole

closeForNextExecution() - Method in class org.postgresql.jdbc.PgStatement

closeOnCompletion() - Method in class org.postgresql.jdbc.PgStatement

closePath() - Method in class org.postgresql.geometric.PGpath

closeStream(PGStream) - Method in class org.postgresql.core.ConnectionFactory

Safely close the given stream.

command - Variable in class org.postgresql.core.NativeQuery

commit() - Method in class org.postgresql.jdbc.PgConnection

commit(Xid, boolean) - Method in class org.postgresql.xa.PGXAConnection

COMMUNICATION_ERROR - Static variable in class org.postgresql.util.PSQLState

CONCAT - Static variable in class org.postgresql.jdbc.EscapedFunctions

concurrency - Variable in class org.postgresql.jdbc.PgStatement

conn - Variable in class org.postgresql.jdbc.AbstractBlobClob

connect(String, Properties) - Method in class org.postgresql.Driver

Try to make a database connection to the given URL.

connection - Variable in class org.postgresql.jdbc.PgArray

A database connection.

connection - Variable in class org.postgresql.jdbc.PgDatabaseMetaData

connection - Variable in class org.postgresql.jdbc.PgResultSet

connection - Variable in class org.postgresql.jdbc.PgResultSetMetaData

connection - Variable in class org.postgresql.jdbc.PgStatement

CONNECTION_DOES_NOT_EXIST - Static variable in class org.postgresql.util.PSQLState

CONNECTION_FAILURE - Static variable in class org.postgresql.util.PSQLState

After a connection has been established, it went bad.

CONNECTION_FAILURE_DURING_TRANSACTION - Static variable in class org.postgresql.util.PSQLState

CONNECTION_REJECTED - Static variable in class org.postgresql.util.PSQLState

The server rejected our connection attempt.

CONNECTION_UNABLE_TO_CONNECT - Static variable in class org.postgresql.util.PSQLState

We could establish a connection with the server for unknown reasons.

ConnectionFactory - Class in org.postgresql.core

Handles protocol-specific connection setup.

ConnectionFactory() - Constructor for class org.postgresql.core.ConnectionFactory

ConnectionFactoryImpl - Class in org.postgresql.core.v3

ConnectionFactory implementation for version 3 (7.4+) connections.

ConnectionFactoryImpl() - Constructor for class org.postgresql.core.v3.ConnectionFactoryImpl

ConnectionPool - Class in org.postgresql.jdbc2.optional

ConnectionPool() - Constructor for class org.postgresql.jdbc2.optional.ConnectionPool

continueSSPI(int) - Method in interface org.postgresql.sspi.ISSPIClient

continueSSPI(int) - Method in class org.postgresql.sspi.SSPIClient

Continue an existing authentication conversation with the back-end in resonse to an authentication request of type AUTH_REQ_GSS_CONT.

convert(PGStream, Properties, Logger) - Static method in class org.postgresql.ssl.MakeSSL

convertArrayToBaseOid(int) - Method in class org.postgresql.jdbc.TypeInfoCache

Return the oid of the array's base element if it's an array, if not return the provided oid.

convertToDate(long, TimeZone) - Method in class org.postgresql.jdbc.TimestampUtils

Extracts the date part from a timestamp.

convertToTime(long, TimeZone) - Method in class org.postgresql.jdbc.TimestampUtils

Extracts the time part from a timestamp.

copy() - Method in interface org.postgresql.core.ParameterList

Perform a shallow copy of this ParameterList, returning a new instance (still suitable for passing to the owning Query).

copy() - Method in class org.postgresql.largeobject.LargeObject

CopyIn - Interface in org.postgresql.copy

Copy bulk data from client into a PostgreSQL table very fast.

copyIn(String) - Method in class org.postgresql.copy.CopyManager

copyIn(String, Reader) - Method in class org.postgresql.copy.CopyManager

Use COPY FROM STDIN for very fast copying from a Reader into a database table.

copyIn(String, Reader, int) - Method in class org.postgresql.copy.CopyManager

Use COPY FROM STDIN for very fast copying from a Reader into a database table.

copyIn(String, InputStream) - Method in class org.postgresql.copy.CopyManager

Use COPY FROM STDIN for very fast copying from an InputStream into a database table.

copyIn(String, InputStream, int) - Method in class org.postgresql.copy.CopyManager

Use COPY FROM STDIN for very fast copying from an InputStream into a database table.

CopyInImpl - Class in org.postgresql.core.v3

Anticipated flow of a COPY FROM STDIN operation: CopyManager.copyIn() ->QueryExecutor.startCopy() - sends given query to server ->processCopyResults(): - receives CopyInResponse from Server - creates new CopyInImpl ->initCopy(): - receives copy metadata from server ->CopyInImpl.init() ->lock() connection for this operation - if query fails an exception is thrown - if query returns wrong CopyOperation, copyIn() cancels it before throwing exception <-return: new CopyInImpl holding lock on connection repeat CopyIn.writeToCopy() for all data ->CopyInImpl.writeToCopy() ->QueryExecutorImpl.writeToCopy() - sends given data ->processCopyResults() - parameterized not to block, just peek for new messages from server - on ErrorResponse, waits until protocol is restored and unlocks connection CopyIn.endCopy() ->CopyInImpl.endCopy() ->QueryExecutorImpl.endCopy() - sends CopyDone - processCopyResults() - on CommandComplete ->CopyOperationImpl.handleCommandComplete() - sets updatedRowCount when applicable - on ReadyForQuery unlock() connection for use by other operations <-return: CopyInImpl.getUpdatedRowCount()

CopyInImpl() - Constructor for class org.postgresql.core.v3.CopyInImpl

CopyManager - Class in org.postgresql.copy

API for PostgreSQL COPY bulk data transfer

CopyManager(BaseConnection) - Constructor for class org.postgresql.copy.CopyManager

CopyOperation - Interface in org.postgresql.copy

Exchange bulk data between client and PostgreSQL database tables.

CopyOperationImpl - Class in org.postgresql.core.v3

CopyOperationImpl() - Constructor for class org.postgresql.core.v3.CopyOperationImpl

copyOut(String) - Method in class org.postgresql.copy.CopyManager

copyOut(String, Writer) - Method in class org.postgresql.copy.CopyManager

Pass results of a COPY TO STDOUT query from database into a Writer.

copyOut(String, OutputStream) - Method in class org.postgresql.copy.CopyManager

Pass results of a COPY TO STDOUT query from database into an OutputStream.

CopyOut - Interface in org.postgresql.copy

CopyOutImpl - Class in org.postgresql.core.v3

Anticipated flow of a COPY TO STDOUT operation: CopyManager.copyOut() ->QueryExecutor.startCopy() - sends given query to server ->processCopyResults(): - receives CopyOutResponse from Server - creates new CopyOutImpl ->initCopy(): - receives copy metadata from server ->CopyOutImpl.init() ->lock() connection for this operation - if query fails an exception is thrown - if query returns wrong CopyOperation, copyOut() cancels it before throwing exception <-returned: new CopyOutImpl holding lock on connection repeat CopyOut.readFromCopy() until null ->CopyOutImpl.readFromCopy() ->QueryExecutorImpl.readFromCopy() ->processCopyResults() - on copydata row from server ->CopyOutImpl.handleCopydata() stores reference to byte array - on CopyDone, CommandComplete, ReadyForQuery ->unlock() connection for use by other operations <-returned: byte array of data received from server or null at end.

CopyOutImpl() - Constructor for class org.postgresql.core.v3.CopyOutImpl

COS - Static variable in class org.postgresql.jdbc.EscapedFunctions

COT - Static variable in class org.postgresql.jdbc.EscapedFunctions

create() - Method in class org.postgresql.largeobject.LargeObjectManager

Deprecated. As of 8.3, replaced by LargeObjectManager.createLO()

create(int) - Method in class org.postgresql.largeobject.LargeObjectManager

Deprecated. As of 8.3, replaced by LargeObjectManager.createLO(int)

create(Key) - Method in interface org.postgresql.util.LruCache.CreateAction

createArrayOf(String, Object[]) - Method in class org.postgresql.jdbc.PgConnection

createBatchHandler(Query[], ParameterList[]) - Method in class org.postgresql.jdbc.PgStatement

createBlob() - Method in class org.postgresql.jdbc.PgConnection

createClob() - Method in class org.postgresql.jdbc.PgConnection

createColumnNameIndexMap(Field[], boolean) - Static method in class org.postgresql.jdbc.PgResultSet

createConnectionEvent(SQLException) - Method in class org.postgresql.ds.PGPooledConnection

createConnectionPool() - Method in class org.postgresql.ds.PGPoolingDataSource

Creates the appropriate ConnectionPool to use for this DataSource.

createConnectionPoolDataSource(Properties) - Method in class org.postgresql.osgi.PGDataSourceFactory

createDataSource(Properties) - Method in class org.postgresql.osgi.PGDataSourceFactory

Will create and return either a SimpleDataSource or a PoolingDataSource depending on the presence in the supplied properties of any pool-related property (eg.: JDBC_INITIAL_POOL_SIZE or JDBC_MAX_POOL_SIZE)

createDriver(Properties) - Method in class org.postgresql.osgi.PGDataSourceFactory

createDriverResultSet(Field[], List<byte[][]>) - Method in interface org.postgresql.core.BaseStatement

Create a synthetic resultset from data provided by the driver.

createDriverResultSet(Field[], List<byte[][]>) - Method in class org.postgresql.jdbc.PgStatement

createFastpathParameters(int) - Method in interface org.postgresql.core.QueryExecutor

Create a new ParameterList implementation suitable for invoking a fastpath function via QueryExecutor.fastpathCall(int, org.postgresql.core.ParameterList, boolean).

createFastpathParameters(int) - Method in class org.postgresql.core.v3.QueryExecutorImpl

createHostChooser(HostSpec[], HostRequirement, Properties) - Static method in class org.postgresql.hostchooser.HostChooserFactory

createLO() - Method in class org.postgresql.largeobject.LargeObjectManager

This creates a large object, returning its OID.

createLO(int) - Method in class org.postgresql.largeobject.LargeObjectManager

This creates a large object, returning its OID

createMetaData() - Method in class org.postgresql.jdbc.PgResultSet

createMetaDataStatement() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

createNClob() - Method in class org.postgresql.jdbc.PgConnection

createOIDArg(long) - Static method in class org.postgresql.fastpath.Fastpath

Creates a FastpathArg with an oid parameter.

createParameterList() - Method in interface org.postgresql.core.Query

Create a ParameterList suitable for storing parameters associated with this Query.

createQuery(String, boolean, boolean, String...) - Method in interface org.postgresql.core.BaseConnection

createQuery(String, boolean, boolean, String...) - Method in interface org.postgresql.core.QueryExecutor

createQuery(String, boolean, boolean, String...) - Method in class org.postgresql.core.QueryExecutorBase

createQuery(String, boolean, boolean, String...) - Method in class org.postgresql.jdbc.PgConnection

createQueryByKey(Object) - Method in interface org.postgresql.core.QueryExecutor

createQueryByKey(Object) - Method in class org.postgresql.core.QueryExecutorBase

createQueryKey(String, boolean, boolean, String...) - Method in interface org.postgresql.core.QueryExecutor

createQueryKey(String, boolean, boolean, String...) - Method in class org.postgresql.core.QueryExecutorBase

createQueryObject(Class<T>) - Method in class org.postgresql.jdbc.PgConnection

createReference() - Method in class org.postgresql.ds.common.BaseDataSource

Generates a reference using the appropriate object factory.

createReference() - Method in class org.postgresql.xa.PGXADataSource

Generates a reference using the appropriate object factory.

createResultSet(Query, Field[], List<byte[][]>, ResultCursor) - Method in interface org.postgresql.core.BaseStatement

Create a resultset from data retrieved from the server.

createResultSet(Query, Field[], List<byte[][]>, ResultCursor) - Method in class org.postgresql.jdbc.PgStatement

createSimpleQuery(String) - Method in interface org.postgresql.core.QueryExecutor

Create an unparameterized Query object suitable for execution by this QueryExecutor.

createSimpleQuery(String) - Method in class org.postgresql.core.v3.QueryExecutorImpl

createSocket(InetAddress, int) - Method in class org.postgresql.ssl.WrappedFactory

createSocket(String, int) - Method in class org.postgresql.ssl.WrappedFactory

createSocket(String, int, InetAddress, int) - Method in class org.postgresql.ssl.WrappedFactory

createSocket(InetAddress, int, InetAddress, int) - Method in class org.postgresql.ssl.WrappedFactory

createSocket(Socket, String, int, boolean) - Method in class org.postgresql.ssl.WrappedFactory

createSQLXML() - Method in class org.postgresql.jdbc.PgConnection

createStatement() - Method in class org.postgresql.jdbc.PgConnection

createStatement(int, int, int) - Method in class org.postgresql.jdbc.PgConnection

createStatement(int, int) - Method in class org.postgresql.jdbc.PgConnection

createStatementTypeInfo(SqlCommandType, boolean, int, int, boolean, int) - Static method in class org.postgresql.core.SqlCommand

createStatementTypeInfo(SqlCommandType) - Static method in class org.postgresql.core.SqlCommand

createStatementTypeInfo(SqlCommandType, boolean) - Static method in class org.postgresql.core.SqlCommand

createStruct(String, Object[]) - Method in class org.postgresql.jdbc.PgConnection

createTypeInfo(BaseConnection, int) - Method in class org.postgresql.jdbc.PgConnection

createXADataSource(Properties) - Method in class org.postgresql.osgi.PGDataSourceFactory

crypt(byte[], byte[]) - Static method in class org.postgresql.util.UnixCrypt

Encrypt a password given the cleartext password and a "salt".

CURDATE - Static variable in class org.postgresql.jdbc.EscapedFunctions

current_row - Variable in class org.postgresql.jdbc.PgResultSet

cursor - Variable in class org.postgresql.jdbc.PgResultSet

CURTIME - Static variable in class org.postgresql.jdbc.EscapedFunctions

D

DATA_ERROR - Static variable in class org.postgresql.util.PSQLState

DATA_TYPE_MISMATCH - Static variable in class org.postgresql.util.PSQLState

DATABASE - Static variable in class org.postgresql.jdbc.EscapedFunctions

dataDefinitionCausesTransactionCommit() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Does a data definition statement within a transaction force the transaction to commit?

dataDefinitionIgnoredInTransactions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

dataSourceName - Variable in class org.postgresql.ds.PGPoolingDataSource

dataSources - Static variable in class org.postgresql.ds.PGPoolingDataSource

DATE - Static variable in class org.postgresql.core.Oid

DATE_ARRAY - Static variable in class org.postgresql.core.Oid

DATE_NEGATIVE_INFINITY - Static variable in interface org.postgresql.PGStatement

DATE_NEGATIVE_SMALLER_INFINITY - Static variable in interface org.postgresql.PGStatement

DATE_POSITIVE_INFINITY - Static variable in interface org.postgresql.PGStatement

DATE_POSITIVE_SMALLER_INFINITY - Static variable in interface org.postgresql.PGStatement

DATETIME_OVERFLOW - Static variable in class org.postgresql.util.PSQLState

DAYNAME - Static variable in class org.postgresql.jdbc.EscapedFunctions

DAYOFMONTH - Static variable in class org.postgresql.jdbc.EscapedFunctions

DAYOFWEEK - Static variable in class org.postgresql.jdbc.EscapedFunctions

DAYOFYEAR - Static variable in class org.postgresql.jdbc.EscapedFunctions

DbKeyStoreSocketFactory - Class in org.postgresql.ssl

DbKeyStoreSocketFactory() - Constructor for class org.postgresql.ssl.DbKeyStoreSocketFactory

DbKeyStoreSocketFactory.DbKeyStoreSocketException - Exception in org.postgresql.ssl

DbKeyStoreSocketFactory.DbKeyStoreSocketException(String) - Constructor for exception org.postgresql.ssl.DbKeyStoreSocketFactory.DbKeyStoreSocketException

debug(String) - Method in class org.postgresql.core.Logger

debug(String, Throwable) - Method in class org.postgresql.core.Logger

DEBUG - Static variable in class org.postgresql.Driver

decode(byte[], int, int) - Method in class org.postgresql.core.Encoding

Decode an array of bytes into a string.

decode(byte[]) - Method in class org.postgresql.core.Encoding

Decode an array of bytes into a string.

decode(byte[], int, int) - Static method in class org.postgresql.core.EncodingPredictor

DECODE - Static variable in class org.postgresql.util.Base64

Specify decoding.

decode(byte[], int, int) - Static method in class org.postgresql.util.Base64

Very low-level access to decoding ASCII characters in the form of a byte array.

decode(String) - Static method in class org.postgresql.util.Base64

Decodes data from Base64 notation, automatically detecting gzip-compressed data and decompressing it.

defaultEncoding() - Static method in class org.postgresql.core.Encoding

Get an Encoding using the default encoding for the JVM.

defaultFetchSize - Variable in class org.postgresql.jdbc.PgConnection

Default fetch size for statement

DEGREES - Static variable in class org.postgresql.jdbc.EscapedFunctions

delete(long) - Method in class org.postgresql.largeobject.LargeObjectManager

This deletes a large object.

delete(int) - Method in class org.postgresql.largeobject.LargeObjectManager

Deprecated. As of 8.3, replaced by LargeObjectManager.delete(long)

deleteRow() - Method in class org.postgresql.jdbc.PgResultSet

deletesAreDetected(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

deregister() - Static method in class org.postgresql.Driver

According to JDBC specification, this driver is registered against DriverManager when the class is loaded.

deriveForMultiBatch(int) - Method in class org.postgresql.core.v3.BatchedQuery

dispose() - Method in interface org.postgresql.sspi.ISSPIClient

dispose() - Method in class org.postgresql.sspi.SSPIClient

Clean up native win32 resources after completion or failure of SSPI authentication.

DIVISION_BY_ZERO - Static variable in class org.postgresql.util.PSQLState

doesMaxRowSizeIncludeBlobs() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

DONT_BREAK_LINES - Static variable in class org.postgresql.util.Base64

Don't break lines when encoding (violates strict Base64 specification)

doSubprotocolBegin() - Method in class org.postgresql.core.v3.QueryExecutorImpl

Driver - Class in org.postgresql

The Java SQL framework allows for multiple database drivers.

Driver() - Constructor for class org.postgresql.Driver

DsMakeSpn(String, String, String, short, String) - Method in class org.postgresql.sspi.NTDSAPIWrapper

Convenience wrapper for NTDSAPI DsMakeSpn with Java friendly string and exception handling.

E

encode(String) - Method in class org.postgresql.core.Encoding

Encode a string to an array of bytes.

ENCODE - Static variable in class org.postgresql.util.Base64

Specify encoding.

encode(byte[], byte[], byte[]) - Static method in class org.postgresql.util.MD5Digest

Encodes user/password/salt information in the following way: MD5(MD5(password + user) + salt)

encodeBytes(byte[]) - Static method in class org.postgresql.util.Base64

Encodes a byte array into Base64 notation.

encodeBytes(byte[], int) - Static method in class org.postgresql.util.Base64

Encodes a byte array into Base64 notation.

encodeBytes(byte[], int, int) - Static method in class org.postgresql.util.Base64

Encodes a byte array into Base64 notation.

encodeBytes(byte[], int, int, int) - Static method in class org.postgresql.util.Base64

Encodes a byte array into Base64 notation.

encodeString(String) - Method in interface org.postgresql.core.BaseConnection

Encode a string using the database's client_encoding (usually UTF8, but can vary on older server versions).

encodeString(String) - Method in class org.postgresql.jdbc.PgConnection

encodeUTF8(String) - Static method in class org.postgresql.core.Utils

Encode a string as UTF-8.

Encoding - Class in org.postgresql.core

Representation of a particular character encoding.

Encoding(String) - Constructor for class org.postgresql.core.Encoding

encoding - Variable in class org.postgresql.core.EncodingPredictor.DecodeResult

EncodingPredictor - Class in org.postgresql.core

Predicts encoding for error messages based on some heuristics: 1) For certain languages, it is known how "FATAL" is translated 2) For Japanese, several common words are hardcoded 3) Then try various LATIN encodings

EncodingPredictor() - Constructor for class org.postgresql.core.EncodingPredictor

EncodingPredictor.DecodeResult - Class in org.postgresql.core

In certain cases the encoding is not known for sure (e.g. before authentication).

end(Xid, int) - Method in class org.postgresql.xa.PGXAConnection

Preconditions: 1.

endCopy() - Method in interface org.postgresql.copy.CopyIn

Finishes copy operation succesfully.

endCopy() - Method in class org.postgresql.copy.PGCopyOutputStream

endCopy() - Method in class org.postgresql.core.v3.CopyInImpl

endCopy(CopyInImpl) - Method in class org.postgresql.core.v3.QueryExecutorImpl

Finishes writing to copy and unlocks connection

ensureBytes(int) - Method in class org.postgresql.core.VisibleBufferedInputStream

Ensures that the buffer contains at least n bytes.

equals(Object) - Method in class org.postgresql.geometric.PGbox

equals(Object) - Method in class org.postgresql.geometric.PGcircle

equals(Object) - Method in class org.postgresql.geometric.PGline

equals(Object) - Method in class org.postgresql.geometric.PGlseg

equals(Object) - Method in class org.postgresql.geometric.PGpath

equals(Object) - Method in class org.postgresql.geometric.PGpoint

equals(Object) - Method in class org.postgresql.geometric.PGpolygon

equals(Object) - Method in class org.postgresql.jdbc.FieldMetadata.Key

equals(Object) - Method in class org.postgresql.util.HostSpec

equals(Object) - Method in class org.postgresql.util.PGInterval

Returns whether an object is equal to this one or not

equals(Object) - Method in class org.postgresql.util.PGmoney

equals(Object) - Method in class org.postgresql.util.PGobject

This must be overidden to allow comparisons of objects

equals(Object) - Method in class org.postgresql.util.PGTime

equals(Object) - Method in class org.postgresql.util.PGTimestamp

equals(Object) - Method in class org.postgresql.util.PSQLState

escapeArrayElement(StringBuilder, String) - Static method in class org.postgresql.jdbc.PgArray

EscapedFunctions - Class in org.postgresql.jdbc

This class stores supported escaped function

EscapedFunctions() - Constructor for class org.postgresql.jdbc.EscapedFunctions

escapeIdentifier(StringBuilder, String) - Static method in class org.postgresql.core.Utils

Escape the given identifier value and append it to the string builder sbuf.

escapeIdentifier(String) - Method in class org.postgresql.jdbc.PgConnection

escapeIdentifier(String) - Method in interface org.postgresql.PGConnection

Return the given string suitably quoted to be used as an identifier in an SQL statement string.

escapeLiteral(StringBuilder, String, boolean) - Static method in class org.postgresql.core.Utils

Escape the given literal value and append it to the string builder sbuf.

escapeLiteral(String) - Method in class org.postgresql.jdbc.PgConnection

escapeLiteral(String) - Method in interface org.postgresql.PGConnection

Return the given string suitably quoted to be used as a string literal in an SQL statement string.

escapeQuotes(String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Turn the provided value into a valid string literal for direct inclusion into a query.

escapeString(String) - Method in interface org.postgresql.core.BaseConnection

Escapes a string for use as string-literal within an SQL command.

escapeString(String) - Method in class org.postgresql.jdbc.PgConnection

evict(Value) - Method in interface org.postgresql.util.LruCache.EvictAction

execSQLQuery(String) - Method in interface org.postgresql.core.BaseConnection

Execute a SQL query that returns a single resultset.

execSQLQuery(String, int, int) - Method in interface org.postgresql.core.BaseConnection

execSQLQuery(String) - Method in class org.postgresql.jdbc.PgConnection

execSQLQuery(String, int, int) - Method in class org.postgresql.jdbc.PgConnection

execSQLUpdate(String) - Method in interface org.postgresql.core.BaseConnection

Execute a SQL query that does not return results.

execSQLUpdate(String) - Method in class org.postgresql.jdbc.PgConnection

execute(Query, ParameterList, ResultHandler, int, int, int) - Method in interface org.postgresql.core.QueryExecutor

Execute a Query, passing results to a provided ResultHandler.

execute(Query[], ParameterList[], BatchResultHandler, int, int, int) - Method in interface org.postgresql.core.QueryExecutor

Execute several Query, passing results to a provided ResultHandler.

execute(Query, ParameterList, ResultHandler, int, int, int) - Method in class org.postgresql.core.v3.QueryExecutorImpl

execute(Query[], ParameterList[], BatchResultHandler, int, int, int) - Method in class org.postgresql.core.v3.QueryExecutorImpl

execute(String) - Method in class org.postgresql.jdbc.PgStatement

execute(CachedQuery, ParameterList, int) - Method in class org.postgresql.jdbc.PgStatement

execute(String, int) - Method in class org.postgresql.jdbc.PgStatement

execute(String, int[]) - Method in class org.postgresql.jdbc.PgStatement

execute(String, String[]) - Method in class org.postgresql.jdbc.PgStatement

executeBatch() - Method in class org.postgresql.jdbc.PgStatement

executeLargeBatch() - Method in class org.postgresql.jdbc.PgStatement

executeLargeUpdate(String) - Method in class org.postgresql.jdbc.PgStatement

executeLargeUpdate(String, int) - Method in class org.postgresql.jdbc.PgStatement

executeLargeUpdate(String, int[]) - Method in class org.postgresql.jdbc.PgStatement

executeLargeUpdate(String, String[]) - Method in class org.postgresql.jdbc.PgStatement

executeLargeUpdate() - Method in class org.postgresql.jdbc.PgStatement

executeQuery(String) - Method in class org.postgresql.jdbc.PgStatement

executeUpdate(String) - Method in class org.postgresql.jdbc.PgStatement

executeUpdate(String, int) - Method in class org.postgresql.jdbc.PgStatement

executeUpdate(String, int[]) - Method in class org.postgresql.jdbc.PgStatement

executeUpdate(String, String[]) - Method in class org.postgresql.jdbc.PgStatement

executeWithFlags(String, int) - Method in interface org.postgresql.core.BaseStatement

Execute a query, passing additional query flags.

executeWithFlags(CachedQuery, int) - Method in interface org.postgresql.core.BaseStatement

Execute a query, passing additional query flags.

executeWithFlags(int) - Method in interface org.postgresql.core.BaseStatement

Execute a prepared query, passing additional query flags.

executeWithFlags(String, int) - Method in class org.postgresql.jdbc.PgStatement

executeWithFlags(CachedQuery, int) - Method in class org.postgresql.jdbc.PgStatement

executeWithFlags(int) - Method in class org.postgresql.jdbc.PgStatement

EXP - Static variable in class org.postgresql.jdbc.EscapedFunctions

F

Fastpath - Class in org.postgresql.fastpath

This class implements the Fastpath api.

Fastpath(BaseConnection) - Constructor for class org.postgresql.fastpath.Fastpath

Initialises the fastpath system

fastpath(int, boolean, FastpathArg[]) - Method in class org.postgresql.fastpath.Fastpath

Deprecated. please use Fastpath.fastpath(int, FastpathArg[])

fastpath(int, FastpathArg[]) - Method in class org.postgresql.fastpath.Fastpath

Send a function call to the PostgreSQL backend

fastpath(String, boolean, FastpathArg[]) - Method in class org.postgresql.fastpath.Fastpath

Deprecated. Use Fastpath.getData(String, FastpathArg[]) if you expect a binary result, or one of Fastpath.getInteger(String, FastpathArg[]) or Fastpath.getLong(String, FastpathArg[]) if you expect a numeric one

fastpath(String, FastpathArg[]) - Method in class org.postgresql.fastpath.Fastpath

Send a function call to the PostgreSQL backend by name.

FastpathArg - Class in org.postgresql.fastpath

Each fastpath call requires an array of arguments, the number and type dependent on the function being called.

FastpathArg(int) - Constructor for class org.postgresql.fastpath.FastpathArg

Constructs an argument that consists of an integer value

FastpathArg(long) - Constructor for class org.postgresql.fastpath.FastpathArg

Constructs an argument that consists of an integer value

FastpathArg(byte[]) - Constructor for class org.postgresql.fastpath.FastpathArg

Constructs an argument that consists of an array of bytes

FastpathArg(byte[], int, int) - Constructor for class org.postgresql.fastpath.FastpathArg

Constructs an argument that consists of part of a byte array

FastpathArg(String) - Constructor for class org.postgresql.fastpath.FastpathArg

Constructs an argument that consists of a String.

fastpathCall(int, ParameterList, boolean) - Method in interface org.postgresql.core.QueryExecutor

Invoke a backend function via the fastpath interface.

fastpathCall(int, ParameterList, boolean) - Method in class org.postgresql.core.v3.QueryExecutorImpl

fetch(ResultCursor, ResultHandler, int) - Method in interface org.postgresql.core.QueryExecutor

Fetch additional rows from a cursor.

fetch(ResultCursor, ResultHandler, int) - Method in class org.postgresql.core.v3.QueryExecutorImpl

fetchdirection - Variable in class org.postgresql.jdbc.PgStatement

fetchSize - Variable in class org.postgresql.jdbc.PgResultSet

fetchSize - Variable in class org.postgresql.jdbc.PgStatement

Number of rows to get in a batch.

Field - Class in org.postgresql.core

Field(String, int, int, int) - Constructor for class org.postgresql.core.Field

Construct a field based on the information fed to it.

Field(String, int) - Constructor for class org.postgresql.core.Field

Constructor without mod parameter.

Field(String, int, int, int, int, int) - Constructor for class org.postgresql.core.Field

Construct a field based on the information fed to it.

fieldBytes - Variable in class org.postgresql.jdbc.PgArray

FieldMetadata - Class in org.postgresql.jdbc

This is an internal class to hold field metadata info like table name, column name, etc.

FieldMetadata(String) - Constructor for class org.postgresql.jdbc.FieldMetadata

FieldMetadata.Key - Class in org.postgresql.jdbc

fields - Variable in class org.postgresql.jdbc.PgResultSet

fields - Variable in class org.postgresql.jdbc.PgResultSetMetaData

fieldString - Variable in class org.postgresql.jdbc.PgArray

Field value as String.

finalize() - Method in class org.postgresql.jdbc.PgConnection

Overrides finalize().

findColumn(String) - Method in class org.postgresql.jdbc.PgResultSet

first() - Method in class org.postgresql.jdbc.PgResultSet

firstUnclosedResult - Variable in class org.postgresql.jdbc.PgStatement

The first unclosed result.

FLOAT4 - Static variable in class org.postgresql.core.Oid

float4(byte[], int) - Static method in class org.postgresql.util.ByteConverter

Parses a float value from the byte array.

float4(byte[], int, float) - Static method in class org.postgresql.util.ByteConverter

Encodes a int value to the byte array.

FLOAT4_ARRAY - Static variable in class org.postgresql.core.Oid

FLOAT8 - Static variable in class org.postgresql.core.Oid

float8(byte[], int) - Static method in class org.postgresql.util.ByteConverter

Parses a double value from the byte array.

float8(byte[], int, double) - Static method in class org.postgresql.util.ByteConverter

Encodes a int value to the byte array.

FLOAT8_ARRAY - Static variable in class org.postgresql.core.Oid

FLOOR - Static variable in class org.postgresql.jdbc.EscapedFunctions

flush() - Method in class org.postgresql.copy.PGCopyOutputStream

flush() - Method in class org.postgresql.core.PGStream

Flush any pending output to the backend.

flush() - Method in class org.postgresql.largeobject.BlobOutputStream

Flushes this output stream and forces any buffered output bytes to be written out.

flushCopy() - Method in interface org.postgresql.copy.CopyIn

Force any buffered output to be sent over the network to the backend.

flushCopy() - Method in class org.postgresql.copy.PGCopyOutputStream

flushCopy() - Method in class org.postgresql.core.v3.CopyInImpl

flushCopy(CopyInImpl) - Method in class org.postgresql.core.v3.QueryExecutorImpl

forcebinary - Variable in class org.postgresql.jdbc.PgConnection

forget(Xid) - Method in class org.postgresql.xa.PGXAConnection

Does nothing, since we don't do heuristics,

forName(String) - Static method in enum org.postgresql.PGProperty

free() - Method in class org.postgresql.jdbc.AbstractBlobClob

free() - Method in class org.postgresql.jdbc.PgArray

free() - Method in class org.postgresql.jdbc.PgSQLXML

from(String) - Static method in enum org.postgresql.core.ServerVersion

Attempt to parse the server version string into an XXYYZZ form version number into a Version.

fromBytes(byte[], Encoding) - Static method in class org.postgresql.util.HStoreConverter

fromString(String) - Static method in class org.postgresql.util.HStoreConverter

G

generatedKeyAlwaysReturned() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

generatedKeys - Variable in class org.postgresql.jdbc.PgStatement

Results returned by a statement that wants generated keys.

get() - Method in interface org.postgresql.core.Provider

Gets a result.

get(Properties) - Method in enum org.postgresql.PGProperty

Returns the value of the connection parameters according to the given Properties or the default value

get(Key) - Method in class org.postgresql.util.LruCache

Returns an entry from the cache.

getAcceptedIssuers() - Method in class org.postgresql.ssl.NonValidatingFactory.NonValidatingTM

getAcceptedIssuers() - Method in class org.postgresql.ssl.SingleCertValidatingFactory.SingleCertTrustManager

getAllowEncodingChanges() - Method in class org.postgresql.ds.common.BaseDataSource

getApplicationName() - Method in interface org.postgresql.core.QueryExecutor

Returns application_name connection property.

getApplicationName() - Method in class org.postgresql.core.v3.QueryExecutorImpl

getApplicationName() - Method in class org.postgresql.ds.common.BaseDataSource

getArray() - Method in class org.postgresql.jdbc.PgArray

getArray(long, int) - Method in class org.postgresql.jdbc.PgArray

getArray(Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgArray

getArray(long, int, Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgArray

getArray(String) - Method in class org.postgresql.jdbc.PgResultSet

getArray(int) - Method in class org.postgresql.jdbc.PgResultSet

getArrayDelimiter(int) - Method in interface org.postgresql.core.TypeInfo

Determine the delimiter for the elements of the given array type oid.

getArrayDelimiter(int) - Method in class org.postgresql.jdbc.TypeInfoCache

getArrayImpl(Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgArray

getArrayImpl(long, int, Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgArray

getAsciiStream() - Method in class org.postgresql.jdbc.PgClob

getAsciiStream(int) - Method in class org.postgresql.jdbc.PgResultSet

getAsciiStream(String) - Method in class org.postgresql.jdbc.PgResultSet

getAssistant(int) - Static method in class org.postgresql.jdbc2.ArrayAssistantRegistry

getAssumeMinServerVersion() - Method in class org.postgresql.ds.common.BaseDataSource

getAttributes(String, String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getAutoCommit() - Method in class org.postgresql.jdbc.PgConnection

getAutoSave() - Method in interface org.postgresql.core.QueryExecutor

getAutoSave() - Method in class org.postgresql.core.QueryExecutorBase

getAutosave() - Method in class org.postgresql.ds.common.BaseDataSource

getAutosave() - Method in class org.postgresql.jdbc.PgConnection

getAutosave() - Method in interface org.postgresql.PGConnection

Connection configuration regarding automatic per-query savepoints.

getBackendPID() - Method in interface org.postgresql.core.QueryExecutor

Return the process ID (PID) of the backend server process handling this connection.

getBackendPID() - Method in class org.postgresql.core.QueryExecutorBase

getBackendPID() - Method in class org.postgresql.jdbc.PgConnection

getBackendPID() - Method in interface org.postgresql.PGConnection

Return the process ID (PID) of the backend server process handling this connection.

getBaseColumnName(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getBaseColumnName(int) - Method in interface org.postgresql.PGResultSetMetaData

Returns the underlying column name of a query result, or "" if it is unable to be determined.

getBaseSchemaName(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getBaseSchemaName(int) - Method in interface org.postgresql.PGResultSetMetaData

Returns the underlying schema name of query result, or "" if it is unable to be determined.

getBaseTableName(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getBaseTableName(int) - Method in interface org.postgresql.PGResultSetMetaData

Returns the underlying table name of query result, or "" if it is unable to be determined.

getBaseType() - Method in class org.postgresql.jdbc.PgArray

getBaseTypeName() - Method in class org.postgresql.jdbc.PgArray

getBatchRewriteValuesBraceClosePosition() - Method in class org.postgresql.core.SqlCommand

getBatchRewriteValuesBraceOpenPosition() - Method in class org.postgresql.core.SqlCommand

getBatchSize() - Method in interface org.postgresql.core.Query

Get the number of times this Query has been batched.

getBatchSize() - Method in class org.postgresql.core.v3.BatchedQuery

getBestRowIdentifier(String, String, String, int, boolean) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getBigDecimal(int) - Method in class org.postgresql.jdbc.PgResultSet

getBigDecimal(String) - Method in class org.postgresql.jdbc.PgResultSet

getBigDecimal(int, int) - Method in class org.postgresql.jdbc.PgResultSet

getBigDecimal(String, int) - Method in class org.postgresql.jdbc.PgResultSet

getBinaryStream() - Method in class org.postgresql.jdbc.AbstractBlobClob

getBinaryStream(long, long) - Method in class org.postgresql.jdbc.PgBlob

getBinaryStream(int) - Method in class org.postgresql.jdbc.PgResultSet

getBinaryStream(String) - Method in class org.postgresql.jdbc.PgResultSet

getBinaryStream() - Method in class org.postgresql.jdbc.PgSQLXML

getBinaryTransfer() - Method in class org.postgresql.ds.common.BaseDataSource

getBinaryTransferDisable() - Method in class org.postgresql.ds.common.BaseDataSource

getBinaryTransferEnable() - Method in class org.postgresql.ds.common.BaseDataSource

getBlob(String) - Method in class org.postgresql.jdbc.PgResultSet

getBlob(int) - Method in class org.postgresql.jdbc.PgResultSet

getBoolean(int) - Method in class org.postgresql.jdbc.PgResultSet

getBoolean(String) - Method in class org.postgresql.jdbc.PgResultSet

getBoolean(Properties) - Method in enum org.postgresql.PGProperty

Return the boolean value for this connection parameter in the given Properties

getBuffer() - Method in class org.postgresql.core.VisibleBufferedInputStream

Returns direct handle to the used buffer.

getByte(int) - Method in class org.postgresql.jdbc.PgResultSet

getByte(String) - Method in class org.postgresql.jdbc.PgResultSet

getBytes(long, int) - Method in class org.postgresql.jdbc.AbstractBlobClob

getBytes(int) - Method in class org.postgresql.jdbc.PgResultSet

In normal use, the bytes represent the raw values returned by the backend.

getBytes(String) - Method in class org.postgresql.jdbc.PgResultSet

getBytes() - Method in class org.postgresql.util.StreamWrapper

getCalendar() - Method in class org.postgresql.util.PGTime

Returns the calendar object for this time.

getCalendar() - Method in class org.postgresql.util.PGTimestamp

Returns the calendar object for this timestamp.

getCancelSignalTimeout() - Method in class org.postgresql.ds.common.BaseDataSource

getCatalog() - Method in class org.postgresql.jdbc.PgConnection

getCatalogName(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getCatalogs() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

PostgreSQL does not support multiple catalogs from a single connection, so to reduce confusion we only return the current catalog.

getCatalogSeparator() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getCatalogTerm() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getCertificateChain(String) - Method in class org.postgresql.ssl.jdbc4.LazyKeyManager

getCharacterStream(long, long) - Method in class org.postgresql.jdbc.PgClob

getCharacterStream() - Method in class org.postgresql.jdbc.PgClob

getCharacterStream(String) - Method in class org.postgresql.jdbc.PgResultSet

getCharacterStream(int) - Method in class org.postgresql.jdbc.PgResultSet

getCharacterStream() - Method in class org.postgresql.jdbc.PgSQLXML

getCharset() - Method in class org.postgresql.ds.common.BaseDataSource

getChoices() - Method in enum org.postgresql.PGProperty

Returns the available values for this connection parameter

getClientAliases(String, Principal[]) - Method in class org.postgresql.ssl.jdbc4.LazyKeyManager

getClientInfo(String) - Method in class org.postgresql.jdbc.PgConnection

getClientInfo() - Method in class org.postgresql.jdbc.PgConnection

getClientInfoProperties() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getClob(String) - Method in class org.postgresql.jdbc.PgResultSet

getClob(int) - Method in class org.postgresql.jdbc.PgResultSet

getColumn() - Method in class org.postgresql.util.ServerErrorMessage

getColumnClassName(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

Returns the fully-qualified name of the Java class whose instances are manufactured if the method ResultSet.getObject is called to retrieve a value from the column.

getColumnCount() - Method in class org.postgresql.jdbc.PgResultSetMetaData

getColumnDisplaySize(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getColumnLabel() - Method in class org.postgresql.core.Field

getColumnLabel(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getColumnName(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getColumnOID(int) - Method in class org.postgresql.jdbc.PgResultSet

Returns the OID of a field.

getColumnPrivileges(String, String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getColumns(int, String, String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getColumns(String, String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getColumnType(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getColumnTypeName(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getCommand() - Method in class org.postgresql.core.NativeQuery

getCompatible() - Method in class org.postgresql.ds.common.BaseDataSource

getConcurrency() - Method in class org.postgresql.jdbc.PgResultSet

getConnection() - Method in class org.postgresql.ds.common.BaseDataSource

Gets a connection to the PostgreSQL database.

getConnection(String, String) - Method in class org.postgresql.ds.common.BaseDataSource

Gets a connection to the PostgreSQL database.

getConnection() - Method in class org.postgresql.ds.PGPooledConnection

Gets a handle for a client to use.

getConnection(String, String) - Method in class org.postgresql.ds.PGPoolingDataSource

Gets a non-pooled connection, unless the user and password are the same as the default values for this connection pool.

getConnection() - Method in class org.postgresql.ds.PGPoolingDataSource

Gets a connection from the connection pool.

getConnection() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getConnection() - Method in class org.postgresql.jdbc.PgStatement

getConnection() - Method in class org.postgresql.xa.PGXAConnection

XAConnection interface

getConnectTimeout() - Method in class org.postgresql.ds.common.BaseDataSource

getConstraint() - Method in class org.postgresql.util.ServerErrorMessage

getCopyAPI() - Method in class org.postgresql.jdbc.PgConnection

getCopyAPI() - Method in interface org.postgresql.PGConnection

This returns the COPY API for the current connection.

getCrossReference(String, String, String, String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getCurrentSchema() - Method in class org.postgresql.ds.common.BaseDataSource

getCursorName() - Method in class org.postgresql.jdbc.PgConnection

getCursorName gets the cursor name.

getCursorName() - Method in class org.postgresql.jdbc.PgResultSet

getData(String, FastpathArg[]) - Method in class org.postgresql.fastpath.Fastpath

This convenience method assumes that the return value is not an Integer

getDatabase() - Method in interface org.postgresql.core.QueryExecutor

getDatabase() - Method in class org.postgresql.core.QueryExecutorBase

getDatabaseEncoding(String) - Static method in class org.postgresql.core.Encoding

Construct an Encoding for a given database encoding.

getDatabaseMajorVersion() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getDatabaseMetadataCacheFields() - Method in class org.postgresql.ds.common.BaseDataSource

getDatabaseMetadataCacheFieldsMiB() - Method in class org.postgresql.ds.common.BaseDataSource

getDatabaseMinorVersion() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getDatabaseName() - Method in class org.postgresql.ds.common.BaseDataSource

Gets the name of the PostgreSQL database, running on the server identified by the serverName property.

getDatabaseProductName() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

What is the name of this database product - we hope that it is PostgreSQL, so we return that explicitly.

getDatabaseProductVersion() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getDataSource(String) - Static method in class org.postgresql.ds.PGPoolingDataSource

getDataSourceName() - Method in class org.postgresql.ds.PGPoolingDataSource

Gets the name of this DataSource.

getDatatype() - Method in class org.postgresql.util.ServerErrorMessage

getDate(int, Calendar) - Method in class org.postgresql.jdbc.PgResultSet

getDate(String, Calendar) - Method in class org.postgresql.jdbc.PgResultSet

getDate(int) - Method in class org.postgresql.jdbc.PgResultSet

getDate(String) - Method in class org.postgresql.jdbc.PgResultSet

getDays() - Method in class org.postgresql.util.PGInterval

Returns the days represented by this interval

getDBVersionNumber() - Method in class org.postgresql.jdbc.PgConnection

Get server version number

getDecodingReader(InputStream) - Method in class org.postgresql.core.Encoding

Get a Reader that decodes the given InputStream using this encoding.

getDefaultCipherSuites() - Method in class org.postgresql.ssl.WrappedFactory

getDefaultFetchSize() - Method in class org.postgresql.jdbc.PgConnection

getDefaultFetchSize() - Method in interface org.postgresql.PGConnection

Get the default fetch size for statements created from this connection

getDefaultRowFetchSize() - Method in class org.postgresql.ds.common.BaseDataSource

getDefaultTransactionIsolation() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getDefaultValue() - Method in enum org.postgresql.PGProperty

Returns the default value for this connection parameter

getDescription() - Method in class org.postgresql.ds.common.BaseDataSource

Gets a description of this DataSource-ish thing.

getDescription() - Method in class org.postgresql.ds.PGConnectionPoolDataSource

Gets a description of this DataSource.

getDescription() - Method in class org.postgresql.ds.PGPoolingDataSource

Gets a description of this DataSource.

getDescription() - Method in class org.postgresql.ds.PGSimpleDataSource

Gets a description of this DataSource.

getDescription() - Method in class org.postgresql.xa.PGXADataSource

getDetail() - Method in class org.postgresql.util.ServerErrorMessage

getDisableColumnSanitiser() - Method in class org.postgresql.ds.common.BaseDataSource

getDisplaySize(int, int) - Method in interface org.postgresql.core.TypeInfo

getDisplaySize(int, int) - Method in class org.postgresql.jdbc.TypeInfoCache

getDouble(int) - Method in class org.postgresql.jdbc.PgResultSet

getDouble(String) - Method in class org.postgresql.jdbc.PgResultSet

getDriverMajorVersion() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getDriverMinorVersion() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getDriverName() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getDriverVersion() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getEncoding() - Method in interface org.postgresql.core.BaseConnection

getEncoding() - Method in class org.postgresql.core.PGStream

getEncoding() - Method in interface org.postgresql.core.QueryExecutor

getEncoding() - Method in class org.postgresql.core.QueryExecutorBase

getEncoding() - Method in class org.postgresql.jdbc.PgConnection

getEncodingWriter(OutputStream) - Method in class org.postgresql.core.Encoding

Get a Writer that encodes to the given OutputStream using this encoding.

getEncodingWriter() - Method in class org.postgresql.core.PGStream

Get a Writer instance that encodes directly onto the underlying stream.

getException() - Method in interface org.postgresql.core.ResultHandler

Returns the first encountered exception.

getException() - Method in class org.postgresql.core.ResultHandlerBase

getException() - Method in class org.postgresql.core.ResultHandlerDelegate

getExecuteCount() - Method in class org.postgresql.core.CachedQuery

Number of times this statement has been used

getExportedKeys(String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getExtraNameCharacters() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Postgresql allows any high-bit character to be used in an unquoted identifier, so we can't possibly list them all.

getFastpathAPI() - Method in class org.postgresql.jdbc.PgConnection

getFastpathAPI() - Method in interface org.postgresql.PGConnection

This returns the Fastpath API for the current connection.

getFetchDirection() - Method in class org.postgresql.jdbc.PgResultSet

getFetchDirection() - Method in class org.postgresql.jdbc.PgStatement

getFetchingCursorName() - Method in class org.postgresql.jdbc.PgStatement

getFetchSize() - Method in class org.postgresql.jdbc.PgResultSet

getFetchSize() - Method in class org.postgresql.jdbc.PgStatement

getField(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getFieldCount() - Method in interface org.postgresql.copy.CopyOperation

getFieldCount() - Method in class org.postgresql.copy.PGCopyInputStream

getFieldCount() - Method in class org.postgresql.copy.PGCopyOutputStream

getFieldCount() - Method in class org.postgresql.core.v3.CopyOperationImpl

getFieldFormat(int) - Method in interface org.postgresql.copy.CopyOperation

getFieldFormat(int) - Method in class org.postgresql.copy.PGCopyInputStream

getFieldFormat(int) - Method in class org.postgresql.copy.PGCopyOutputStream

getFieldFormat(int) - Method in class org.postgresql.core.v3.CopyOperationImpl

getFieldMetadataCache() - Method in interface org.postgresql.core.BaseConnection

Return metadata cache for given connection

getFieldMetadataCache() - Method in class org.postgresql.jdbc.PgConnection

getFile() - Method in class org.postgresql.util.ServerErrorMessage

getFixedString(int) - Method in class org.postgresql.jdbc.PgResultSet

This is used to fix get*() methods on Money fields.

getFloat(int) - Method in class org.postgresql.jdbc.PgResultSet

getFloat(String) - Method in class org.postgresql.jdbc.PgResultSet

getForceBinary() - Method in class org.postgresql.jdbc.PgConnection

getForceBinaryTransfer() - Method in class org.postgresql.jdbc.PgStatement

getFormat() - Method in interface org.postgresql.copy.CopyOperation

getFormat() - Method in class org.postgresql.copy.PGCopyInputStream

getFormat() - Method in class org.postgresql.copy.PGCopyOutputStream

getFormat() - Method in class org.postgresql.core.Field

getFormat() - Method in class org.postgresql.core.v3.CopyOperationImpl

getFormat(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getFormat(int) - Method in interface org.postgresql.PGResultSetMetaData

Is a column Text or Binary?

getFunction(String) - Static method in class org.postgresql.jdbc.EscapedFunctions

get Method object implementing the given function

getFunctionColumns(String, String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getFunctions(String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getGeneratedKeys() - Method in class org.postgresql.jdbc.BatchResultHandler

getGeneratedKeys() - Method in class org.postgresql.jdbc.PgStatement

getGssLib() - Method in class org.postgresql.ds.common.BaseDataSource

getHandledRowCount() - Method in interface org.postgresql.copy.CopyOperation

After succesful end of copy, returns the number of database records handled in that operation.

getHandledRowCount() - Method in class org.postgresql.copy.PGCopyInputStream

getHandledRowCount() - Method in class org.postgresql.copy.PGCopyOutputStream

getHandledRowCount() - Method in class org.postgresql.core.v3.CopyOperationImpl

getHint() - Method in class org.postgresql.util.ServerErrorMessage

getHoldability() - Method in class org.postgresql.jdbc.PgConnection

getHoldability() - Method in class org.postgresql.jdbc.PgResultSet

getHost() - Method in class org.postgresql.util.HostSpec

getHostRecheckSeconds() - Method in class org.postgresql.ds.common.BaseDataSource

getHostSpec() - Method in class org.postgresql.core.PGStream

getHostSpec() - Method in interface org.postgresql.core.QueryExecutor

getHostSpec() - Method in class org.postgresql.core.QueryExecutorBase

getHours() - Method in class org.postgresql.util.PGInterval

Returns the hours represented by this interval

getID(String) - Method in class org.postgresql.fastpath.Fastpath

This returns the function id associated by its name.

getIdentifierQuoteString() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

What is the string used to quote SQL identifiers?

getImportedExportedKeys(String, String, String, String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getImportedKeys(String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getIndex() - Method in class org.postgresql.core.VisibleBufferedInputStream

Returns the current read position in the buffer.

getIndexInfo(String, String, String, boolean, boolean) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getInitialConnections() - Method in class org.postgresql.ds.PGPoolingDataSource

Gets the number of connections that will be created when this DataSource is initialized.

getInParameterCount() - Method in interface org.postgresql.core.ParameterList

Get the number of IN parameters in this list.

getInputStream() - Method in class org.postgresql.largeobject.LargeObject

Returns an InputStream from this object.

getInputStream(long) - Method in class org.postgresql.largeobject.LargeObject

Returns an InputStream from this object, that will limit the amount of data that is visible

getInsertOID() - Method in class org.postgresql.jdbc.ResultWrapper

getInt(int) - Method in class org.postgresql.jdbc.PgResultSet

getInt(String) - Method in class org.postgresql.jdbc.PgResultSet

getInt(Properties) - Method in enum org.postgresql.PGProperty

Return the int value for this connection parameter in the given Properties

getInteger(String, FastpathArg[]) - Method in class org.postgresql.fastpath.Fastpath

This convenience method assumes that the return value is an integer

getInteger(Properties) - Method in enum org.postgresql.PGProperty

Return the Integer value for this connection parameter in the given Properties

getIntegerDateTimes() - Method in interface org.postgresql.core.QueryExecutor

Returns true if server uses integer instead of double for binary date and time encodings.

getIntegerDateTimes() - Method in class org.postgresql.core.v3.QueryExecutorImpl

getInternalPosition() - Method in class org.postgresql.util.ServerErrorMessage

getInternalQuery() - Method in class org.postgresql.util.ServerErrorMessage

getIntNoCheck(Properties) - Method in enum org.postgresql.PGProperty

Return the int value for this connection parameter in the given Properties.

getIOException() - Method in exception org.postgresql.core.PGBindException

getIsolationLevelName(int) - Method in class org.postgresql.jdbc.PgConnection

getJaasApplicationName() - Method in class org.postgresql.ds.common.BaseDataSource

getJavaClass(int) - Method in interface org.postgresql.core.TypeInfo

getJavaClass(int) - Method in class org.postgresql.jdbc.TypeInfoCache

getJDBCMajorVersion() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getJDBCMinorVersion() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getJVMEncoding(String) - Static method in class org.postgresql.core.Encoding

Construct an Encoding for a given JVM encoding.

getKerberosServerName() - Method in class org.postgresql.ds.common.BaseDataSource

getKeyStorePassword() - Method in class org.postgresql.ssl.DbKeyStoreSocketFactory

getKeyStoreStream() - Method in class org.postgresql.ssl.DbKeyStoreSocketFactory

getLargeMaxRows() - Method in class org.postgresql.jdbc.PgStatement

getLargeObjectAPI() - Method in class org.postgresql.jdbc.PgConnection

getLargeObjectAPI() - Method in interface org.postgresql.PGConnection

This returns the LargeObject API for the current connection.

getLargeUpdateCount() - Method in class org.postgresql.jdbc.PgStatement

getLastOID() - Method in class org.postgresql.jdbc.PgStatement

getLastOID() - Method in interface org.postgresql.PGStatement

Returns the Last inserted/updated oid.

getLength() - Method in class org.postgresql.core.Field

getLength() - Method in class org.postgresql.util.StreamWrapper

getLine() - Method in class org.postgresql.util.ServerErrorMessage

getLo(boolean) - Method in class org.postgresql.jdbc.AbstractBlobClob

getLoadBalanceHosts() - Method in class org.postgresql.ds.common.BaseDataSource

getLogger() - Method in interface org.postgresql.core.BaseConnection

getLogger() - Method in class org.postgresql.jdbc.PgConnection

getLoginTimeout() - Method in class org.postgresql.ds.common.BaseDataSource

getLogLevel() - Method in class org.postgresql.core.Logger

getLogLevel() - Static method in class org.postgresql.Driver

getLogLevel() - Method in class org.postgresql.ds.common.BaseDataSource

getLoglevel() - Method in class org.postgresql.ds.common.BaseDataSource

getLogUnclosedConnections() - Method in class org.postgresql.ds.common.BaseDataSource

getLogWriter() - Method in class org.postgresql.ds.common.BaseDataSource

Gets the log writer used to log connections opened.

getLong(String, FastpathArg[]) - Method in class org.postgresql.fastpath.Fastpath

This convenience method assumes that the return value is a long (bigint)

getLong(int) - Method in class org.postgresql.jdbc.PgResultSet

getLong(String) - Method in class org.postgresql.jdbc.PgResultSet

getLongOID() - Method in class org.postgresql.largeobject.LargeObject

getMajorVersion() - Method in class org.postgresql.Driver

Gets the drivers major version number

getMaxBinaryLiteralLength() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxCatalogNameLength() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxCharLiteralLength() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxColumnNameLength() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxColumnsInGroupBy() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxColumnsInIndex() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxColumnsInOrderBy() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxColumnsInSelect() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxColumnsInTable() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

What is the maximum number of columns in a table?

getMaxConnections() - Method in class org.postgresql.ds.PGPoolingDataSource

Gets the maximum number of connections that the pool will allow.

getMaxConnections() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

How many active connection can we have at a time to this database?

getMaxCursorNameLength() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxFieldSize() - Method in class org.postgresql.jdbc.PgStatement

getMaximumPrecision(int) - Method in interface org.postgresql.core.TypeInfo

getMaximumPrecision(int) - Method in class org.postgresql.jdbc.TypeInfoCache

getMaxIndexKeys() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxIndexLength() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxLogicalLobSize() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxNameLength() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxProcedureNameLength() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxRows() - Method in class org.postgresql.jdbc.PgStatement

getMaxRowSize() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxSchemaNameLength() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxStatementLength() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxStatements() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxTableNameLength() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxTablesInSelect() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMaxUserNameLength() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getMessage() - Method in exception org.postgresql.util.PSQLWarning

getMessage() - Method in class org.postgresql.util.ServerErrorMessage

getMetadata() - Method in class org.postgresql.core.Field

getMetaData() - Method in class org.postgresql.jdbc.PgConnection

getMetaData() - Method in class org.postgresql.jdbc.PgResultSet

getMinorVersion() - Method in class org.postgresql.Driver

Get the drivers minor version number

getMinutes() - Method in class org.postgresql.util.PGInterval

Returns the minutes represented by this interval

getMod() - Method in class org.postgresql.core.Field

getMonths() - Method in class org.postgresql.util.PGInterval

Returns the months represented by this interval

getMoreResults() - Method in class org.postgresql.jdbc.PgStatement

getMoreResults(int) - Method in class org.postgresql.jdbc.PgStatement

getName() - Method in class org.postgresql.core.Notification

getName() - Method in interface org.postgresql.PGNotification

Returns name of this notification

getName() - Method in enum org.postgresql.PGProperty

Returns the name of the connection parameter.

getNativeSql() - Method in interface org.postgresql.core.Query

Returns SQL in native for database format

getNativeSql() - Method in class org.postgresql.core.v3.BatchedQuery

Method to return the sql based on number of batches.

getNCharacterStream(int) - Method in class org.postgresql.jdbc.PgResultSet

getNCharacterStream(String) - Method in class org.postgresql.jdbc.PgResultSet

getNClob(int) - Method in class org.postgresql.jdbc.PgResultSet

getNClob(String) - Method in class org.postgresql.jdbc.PgResultSet

getNetworkTimeout() - Method in class org.postgresql.jdbc.PgConnection

getNext() - Method in class org.postgresql.jdbc.ResultWrapper

getNotifications() - Method in interface org.postgresql.core.QueryExecutor

Retrieve and clear the set of asynchronous notifications pending on this connection.

getNotifications() - Method in class org.postgresql.core.QueryExecutorBase

getNotifications() - Method in class org.postgresql.jdbc.PgConnection

getNotifications() - Method in interface org.postgresql.PGConnection

This method returns any notifications that have been received since the last call to this method.

getNString(int) - Method in class org.postgresql.jdbc.PgResultSet

getNString(String) - Method in class org.postgresql.jdbc.PgResultSet

getNumericFunctions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getObject(String, String, byte[]) - Method in interface org.postgresql.core.BaseConnection

Construct and return an appropriate object for the given type and value.

getObject(String, String, byte[]) - Method in class org.postgresql.jdbc.PgConnection

getObject(int) - Method in class org.postgresql.jdbc.PgResultSet

getObject(String) - Method in class org.postgresql.jdbc.PgResultSet

getObject(int, Class<T>) - Method in class org.postgresql.jdbc.PgResultSet

getObject(String, Class<T>) - Method in class org.postgresql.jdbc.PgResultSet

getObject(String, Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgResultSet

getObject(int, Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgResultSet

getObjectImpl(String, Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgResultSet

getObjectImpl(int, Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgResultSet

getObjectInstance(Object, Name, Context, Hashtable<?, ?>) - Method in class org.postgresql.ds.common.PGObjectFactory

Dereferences a PostgreSQL DataSource.

getObjectInstance(Object, Name, Context, Hashtable<?, ?>) - Method in class org.postgresql.xa.PGXADataSourceFactory

getOffset() - Method in class org.postgresql.util.StreamWrapper

getOID() - Method in class org.postgresql.core.Field

getOID(String, FastpathArg[]) - Method in class org.postgresql.fastpath.Fastpath

This convenience method assumes that the return value is an oid.

getOID() - Method in class org.postgresql.largeobject.LargeObject

Deprecated. As of 8.3, replaced by LargeObject.getLongOID()

getOutParameterCount() - Method in interface org.postgresql.core.ParameterList

Get the number of OUT parameters in this list.

getOutputStream() - Method in class org.postgresql.largeobject.LargeObject

Returns an OutputStream to this object.

getParameter() - Method in class org.postgresql.core.Notification

getParameter() - Method in interface org.postgresql.PGNotification

Returns additional information from the notifying process.

getParameterClassName(int) - Method in class org.postgresql.jdbc.PgParameterMetaData

getParameterCount() - Method in interface org.postgresql.core.ParameterList

Get the number of parameters in this list.

getParameterCount() - Method in class org.postgresql.jdbc.PgParameterMetaData

getParameterMode(int) - Method in class org.postgresql.jdbc.PgParameterMetaData

For now report all parameters as inputs.

getParameterType(int) - Method in class org.postgresql.jdbc.PgParameterMetaData

getParameterTypeName(int) - Method in class org.postgresql.jdbc.PgParameterMetaData

getParentLogger() - Method in class org.postgresql.Driver

getParentLogger() - Method in class org.postgresql.ds.PGConnectionPoolDataSource

getParentLogger() - Method in class org.postgresql.ds.PGPooledConnection

getParentLogger() - Method in class org.postgresql.ds.PGPoolingDataSource

getParentLogger() - Method in class org.postgresql.ds.PGSimpleDataSource

getParentLogger() - Method in class org.postgresql.jdbc.PgStatement

getParentLogger() - Method in class org.postgresql.xa.PGXADataSource

getPassword() - Method in class org.postgresql.ds.common.BaseDataSource

Gets the password to connect with by default.

getPGArrayElement(int) - Method in interface org.postgresql.core.TypeInfo

Look up the oid of an array's base type given the array's type oid.

getPGArrayElement(int) - Method in class org.postgresql.jdbc.TypeInfoCache

getPGArrayType(String) - Method in interface org.postgresql.core.TypeInfo

Determine the oid of the given base postgresql type's array type

getPGArrayType(String) - Method in class org.postgresql.jdbc.TypeInfoCache

getPGConnection() - Method in class org.postgresql.jdbc.PgStatement

getPGName() - Method in class org.postgresql.jdbc.PSQLSavepoint

getPGobject(String) - Method in interface org.postgresql.core.TypeInfo

getPGobject(String) - Method in class org.postgresql.jdbc.TypeInfoCache

getPGStatement() - Method in class org.postgresql.jdbc.PgResultSet

getPGType() - Method in class org.postgresql.core.Field

getPGType(String) - Method in interface org.postgresql.core.TypeInfo

Look up the oid for a given postgresql type name.

getPGType(int) - Method in interface org.postgresql.core.TypeInfo

Look up the postgresql type name for a given oid.

getPGType(int) - Method in class org.postgresql.jdbc.PgResultSet

getPGType(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getPGType(String) - Method in class org.postgresql.jdbc.TypeInfoCache

getPGType(int) - Method in class org.postgresql.jdbc.TypeInfoCache

getPGTypeNamesWithSQLTypes() - Method in interface org.postgresql.core.TypeInfo

getPGTypeNamesWithSQLTypes() - Method in class org.postgresql.jdbc.TypeInfoCache

getPID() - Method in class org.postgresql.core.Notification

getPID() - Method in interface org.postgresql.PGNotification

Returns the process id of the backend process making this notification

getPooledConnection() - Method in class org.postgresql.ds.PGConnectionPoolDataSource

Gets a connection which may be pooled by the app server or middleware implementation of DataSource.

getPooledConnection(String, String) - Method in class org.postgresql.ds.PGConnectionPoolDataSource

Gets a connection which may be pooled by the app server or middleware implementation of DataSource.

getPort() - Method in class org.postgresql.util.HostSpec

getPortNumber() - Method in class org.postgresql.ds.common.BaseDataSource

Gets the port which the PostgreSQL server is listening on for TCP/IP connections.

getPosition() - Method in class org.postgresql.util.ServerErrorMessage

getPositionInTable() - Method in class org.postgresql.core.Field

getPrecision(int, int) - Method in interface org.postgresql.core.TypeInfo

getPrecision(int) - Method in class org.postgresql.jdbc.PgParameterMetaData

getPrecision(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getPrecision(int, int) - Method in class org.postgresql.jdbc.TypeInfoCache

getPreferQueryMode() - Method in interface org.postgresql.core.QueryExecutor

getPreferQueryMode() - Method in class org.postgresql.core.QueryExecutorBase

getPreferQueryMode() - Method in class org.postgresql.ds.common.BaseDataSource

getPreferQueryMode() - Method in class org.postgresql.jdbc.PgConnection

getPreferQueryMode() - Method in interface org.postgresql.PGConnection

Returns true if the connection is configured to use "simple 'Q' execute" commands only When running in simple protocol only, certain features are not available: callable statements, partial result set fetch, bytea type, etc.

getPreparedStatementCacheQueries() - Method in class org.postgresql.ds.common.BaseDataSource

getPreparedStatementCacheSizeMiB() - Method in class org.postgresql.ds.common.BaseDataSource

getPrepareThreshold() - Method in class org.postgresql.ds.common.BaseDataSource

getPrepareThreshold() - Method in class org.postgresql.jdbc.PgConnection

getPrepareThreshold() - Method in class org.postgresql.jdbc.PgStatement

getPrepareThreshold() - Method in interface org.postgresql.PGConnection

Get the default server-side prepare reuse threshold for statements created from this connection.

getPrepareThreshold() - Method in interface org.postgresql.PGStatement

Gets the server-side prepare reuse threshold in use for this statement.

getPrimaryKeys(String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getPrivateKey(String) - Method in class org.postgresql.ssl.jdbc4.LazyKeyManager

getProcedureColumns(String, String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getProcedureColumns(int, String, String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getProcedures(String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getProcedures(int, String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getProcedureTerm() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getProperty(String) - Method in class org.postgresql.ds.common.BaseDataSource

getProperty(PGProperty) - Method in class org.postgresql.ds.common.BaseDataSource

getProperty(Reference, String) - Method in class org.postgresql.ds.common.PGObjectFactory

getPropertyInfo(String, Properties) - Method in class org.postgresql.Driver

The getPropertyInfo method is intended to allow a generic GUI tool to discover what properties it should prompt a human for in order to get enough information to connect to a database.

getProtocolVersion() - Method in interface org.postgresql.core.QueryExecutor

getProtocolVersion() - Method in class org.postgresql.core.v3.QueryExecutorImpl

getProtocolVersion() - Method in class org.postgresql.ds.common.BaseDataSource

getProtocolVersion() - Method in class org.postgresql.jdbc.PgConnection

getPseudoColumns(String, String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getQueryExecutor() - Method in interface org.postgresql.core.BaseConnection

Get the QueryExecutor implementation for this connection.

getQueryExecutor() - Method in class org.postgresql.jdbc.PgConnection

getQueryTimeout() - Method in class org.postgresql.jdbc.PgStatement

getQueryTimeoutMs() - Method in class org.postgresql.jdbc.PgStatement

The queryTimeout limit is the number of milliseconds the driver will wait for a Statement to execute.

getReadOnly() - Method in class org.postgresql.ds.common.BaseDataSource

getReceiveBufferSize() - Method in class org.postgresql.ds.common.BaseDataSource

getRef(String) - Method in class org.postgresql.jdbc.PgResultSet

getRef(int) - Method in class org.postgresql.jdbc.PgResultSet

getRefCount() - Method in class org.postgresql.util.SharedTimer

getRefCursor() - Method in class org.postgresql.jdbc.PgResultSet

getRefCursor() - Method in interface org.postgresql.PGRefCursorResultSet

Deprecated. As of 8.0, replaced with calling getString() on the ResultSet that this ResultSet was obtained from.

getReference() - Method in class org.postgresql.ds.common.BaseDataSource

getReference() - Method in class org.postgresql.ds.PGPoolingDataSource

Adds custom properties for this DataSource to the properties defined in the superclass.

getResultSet() - Method in class org.postgresql.jdbc.PgArray

getResultSet(long, int) - Method in class org.postgresql.jdbc.PgArray

getResultSet(Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgArray

getResultSet(long, int, Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgArray

getResultSet() - Method in class org.postgresql.jdbc.PgStatement

getResultSet() - Method in class org.postgresql.jdbc.ResultWrapper

getResultSetColumnNameIndexMap() - Method in interface org.postgresql.core.Query

Get a map that a result set can use to find the index associated to a name.

getResultSetConcurrency() - Method in class org.postgresql.jdbc.PgStatement

getResultSetHoldability() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getResultSetHoldability() - Method in class org.postgresql.jdbc.PgStatement

getResultSetImpl(Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgArray

getResultSetImpl(long, int, Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgArray

getResultSetType() - Method in class org.postgresql.jdbc.PgStatement

getReWriteBatchedInserts() - Method in class org.postgresql.ds.common.BaseDataSource

getRoutine() - Method in class org.postgresql.util.ServerErrorMessage

getRow() - Method in class org.postgresql.jdbc.PgResultSet

getRowId(int) - Method in class org.postgresql.jdbc.PgResultSet

getRowId(String) - Method in class org.postgresql.jdbc.PgResultSet

getRowIdLifetime() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getSavepointId() - Method in class org.postgresql.jdbc.PSQLSavepoint

getSavepointName() - Method in class org.postgresql.jdbc.PSQLSavepoint

getScale(int, int) - Method in interface org.postgresql.core.TypeInfo

getScale(int) - Method in class org.postgresql.jdbc.PgParameterMetaData

getScale(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getScale(int, int) - Method in class org.postgresql.jdbc.TypeInfoCache

getSchema() - Method in class org.postgresql.jdbc.PgConnection

getSchema() - Method in class org.postgresql.util.ServerErrorMessage

getSchemaName(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getSchemas() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getSchemas(int, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getSchemas(String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getSchemaTerm() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

PostgreSQL doesn't have schemas, but when it does, we'll use the term "schema".

getSearchStringEscape() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getSeconds() - Method in class org.postgresql.util.PGInterval

Returns the seconds represented by this interval

getSendBufferSize() - Method in class org.postgresql.ds.common.BaseDataSource

getServerAliases(String, Principal[]) - Method in class org.postgresql.ssl.jdbc4.LazyKeyManager

getServerErrorMessage() - Method in exception org.postgresql.util.PSQLException

getServerErrorMessage() - Method in exception org.postgresql.util.PSQLWarning

getServerMajorVersion() - Method in class org.postgresql.jdbc.PgConnection

Get server major version

getServerMinorVersion() - Method in class org.postgresql.jdbc.PgConnection

Get server minor version

getServerName() - Method in class org.postgresql.ds.common.BaseDataSource

Gets the name of the host the PostgreSQL database is running on.

getServerVersion() - Method in interface org.postgresql.core.QueryExecutor

Return the server version from the server_version GUC.

getServerVersion() - Method in class org.postgresql.core.QueryExecutorBase

getServerVersionNum() - Method in interface org.postgresql.core.QueryExecutor

Get a machine-readable server version.

getServerVersionNum() - Method in class org.postgresql.core.QueryExecutorBase

getSetString(Properties) - Method in enum org.postgresql.PGProperty

Return the property if exists but avoiding the default.

getSeverity() - Method in class org.postgresql.util.ServerErrorMessage

getSharedCalendar(TimeZone) - Method in class org.postgresql.jdbc.TimestampUtils

Get a shared calendar, applying the supplied time zone or the default time zone if null.

getSharedTimer() - Static method in class org.postgresql.Driver

getShort(int) - Method in class org.postgresql.jdbc.PgResultSet

getShort(String) - Method in class org.postgresql.jdbc.PgResultSet

getSize() - Method in class org.postgresql.core.CachedQuery

getSize() - Method in class org.postgresql.jdbc.FieldMetadata

getSize() - Method in interface org.postgresql.util.CanEstimateSize

getSize() - Method in class org.postgresql.util.PGtokenizer

getSocket() - Method in class org.postgresql.core.PGStream

getSocketFactory() - Method in class org.postgresql.core.PGStream

getSocketFactory(Properties) - Static method in class org.postgresql.core.SocketFactoryFactory

Instantiates SocketFactory based on the PGProperty.SOCKET_FACTORY

getSocketFactory() - Method in class org.postgresql.ds.common.BaseDataSource

getSocketFactoryArg() - Method in class org.postgresql.ds.common.BaseDataSource

getSocketTimeout() - Method in class org.postgresql.ds.common.BaseDataSource

getSource(Class<T>) - Method in class org.postgresql.jdbc.PgSQLXML

getSql() - Method in class org.postgresql.core.JdbcCallParseInfo

SQL in a native for certain backend version

getSqlCommand() - Method in interface org.postgresql.core.Query

Returns properties of the query (sql keyword, and some other parsing info).

getSQLKeywords() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Within PostgreSQL, the keywords are found in src/backend/parser/keywords.c For SQL Keywords, I took the list provided at http://web.dementia.org/~ shadow/sql/sql3bnf.sep93.txt which is for SQL3, not SQL-92, but it is close enough for this purpose.

getSQLState() - Method in exception org.postgresql.util.PSQLWarning

getSQLState() - Method in class org.postgresql.util.ServerErrorMessage

getSQLStateType() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getSQLType() - Method in class org.postgresql.core.Field

getSQLType(int) - Method in interface org.postgresql.core.TypeInfo

Look up the SQL typecode for a given type oid.

getSQLType(String) - Method in interface org.postgresql.core.TypeInfo

Look up the SQL typecode for a given postgresql type name.

getSQLType(int) - Method in class org.postgresql.jdbc.PgResultSet

getSQLType(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getSQLType(int) - Method in class org.postgresql.jdbc.TypeInfoCache

getSQLType(String) - Method in class org.postgresql.jdbc.TypeInfoCache

getSQLXML(int) - Method in class org.postgresql.jdbc.PgResultSet

getSQLXML(String) - Method in class org.postgresql.jdbc.PgResultSet

getSsl() - Method in class org.postgresql.ds.common.BaseDataSource

getSslCert() - Method in class org.postgresql.ds.common.BaseDataSource

getSslfactory() - Method in class org.postgresql.ds.common.BaseDataSource

getSslFactoryArg() - Method in class org.postgresql.ds.common.BaseDataSource

getSslHostnameVerifier() - Method in class org.postgresql.ds.common.BaseDataSource

getSslKey() - Method in class org.postgresql.ds.common.BaseDataSource

getSslMode() - Method in class org.postgresql.ds.common.BaseDataSource

getSslPassword() - Method in class org.postgresql.ds.common.BaseDataSource

getSslPasswordCallback() - Method in class org.postgresql.ds.common.BaseDataSource

getSslRootCert() - Method in class org.postgresql.ds.common.BaseDataSource

getSspiServiceClass() - Method in class org.postgresql.ds.common.BaseDataSource

getStandardConformingStrings() - Method in interface org.postgresql.core.BaseConnection

Returns whether the server treats string-literals according to the SQL standard or if it uses traditional PostgreSQL escaping rules.

getStandardConformingStrings() - Method in interface org.postgresql.core.QueryExecutor

Returns whether the server treats string-literals according to the SQL standard or if it uses traditional PostgreSQL escaping rules.

getStandardConformingStrings() - Method in class org.postgresql.core.QueryExecutorBase

getStandardConformingStrings() - Method in class org.postgresql.jdbc.PgConnection

getState() - Method in class org.postgresql.util.PSQLState

getStatement() - Method in class org.postgresql.jdbc.PgResultSet

getStream() - Method in class org.postgresql.util.StreamWrapper

getString(int) - Method in class org.postgresql.jdbc.PgResultSet

getString(String) - Method in class org.postgresql.jdbc.PgResultSet

getString() - Method in class org.postgresql.jdbc.PgSQLXML

getStringFunctions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getStringType() - Method in class org.postgresql.ds.common.BaseDataSource

getStringVarcharFlag() - Method in interface org.postgresql.core.BaseConnection

getStringVarcharFlag() - Method in class org.postgresql.jdbc.PgConnection

getSubqueries() - Method in interface org.postgresql.core.Query

Return a list of the Query objects that make up this query.

getSubString(long, int) - Method in class org.postgresql.jdbc.PgClob

getSuperTables(String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getSuperTypes(String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getSupportedCipherSuites() - Method in class org.postgresql.ssl.WrappedFactory

getSystemFunctions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getTable() - Method in class org.postgresql.util.ServerErrorMessage

getTableName(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

getTableOid() - Method in class org.postgresql.core.Field

getTablePrivileges(String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getTables(String, String, String, String[]) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getTableTypes() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getTargetServerType() - Method in class org.postgresql.ds.common.BaseDataSource

getTcpKeepAlive() - Method in class org.postgresql.ds.common.BaseDataSource

getTime(int, Calendar) - Method in class org.postgresql.jdbc.PgResultSet

getTime(String, Calendar) - Method in class org.postgresql.jdbc.PgResultSet

getTime(int) - Method in class org.postgresql.jdbc.PgResultSet

getTime(String) - Method in class org.postgresql.jdbc.PgResultSet

getTimeDateFunctions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getTimer() - Method in class org.postgresql.util.SharedTimer

getTimestamp(int, Calendar) - Method in class org.postgresql.jdbc.PgResultSet

getTimestamp(String, Calendar) - Method in class org.postgresql.jdbc.PgResultSet

getTimestamp(int) - Method in class org.postgresql.jdbc.PgResultSet

getTimestamp(String) - Method in class org.postgresql.jdbc.PgResultSet

getTimestampUtils() - Method in interface org.postgresql.core.BaseConnection

getTimestampUtils() - Method in class org.postgresql.jdbc.PgConnection

getTimeZone() - Method in interface org.postgresql.core.QueryExecutor

Returns backend timezone in java format.

getTimeZone() - Method in class org.postgresql.core.v3.QueryExecutorImpl

getToken(int) - Method in class org.postgresql.util.PGtokenizer

getTransactionIsolation() - Method in class org.postgresql.jdbc.PgConnection

getTransactionState() - Method in interface org.postgresql.core.BaseConnection

Get the current transaction state of this connection.

getTransactionState() - Method in interface org.postgresql.core.QueryExecutor

Get the current transaction state of this connection.

getTransactionState() - Method in class org.postgresql.core.QueryExecutorBase

getTransactionState() - Method in class org.postgresql.jdbc.PgConnection

getTransactionTimeout() - Method in class org.postgresql.xa.PGXAConnection

We don't do transaction timeouts.

getType() - Method in class org.postgresql.core.SqlCommand

getType() - Method in class org.postgresql.jdbc.PgResultSet

getType() - Method in class org.postgresql.util.PGobject

As this cannot change during the life of the object, it's final.

getTypeForAlias(String) - Method in interface org.postgresql.core.TypeInfo

getTypeForAlias(String) - Method in class org.postgresql.jdbc.TypeInfoCache

getTypeInfo() - Method in interface org.postgresql.core.BaseConnection

getTypeInfo() - Method in class org.postgresql.jdbc.PgConnection

getTypeInfo() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getTypeMap() - Method in class org.postgresql.jdbc.PgConnection

getTypeOIDs() - Method in interface org.postgresql.core.ParameterList

Return the oids of the parameters in this list.

getUDTs(String, String, String, int[]) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getUnicodeStream(int) - Method in class org.postgresql.jdbc.PgResultSet

getUnicodeStream(String) - Method in class org.postgresql.jdbc.PgResultSet

getUnknownLength() - Method in class org.postgresql.ds.common.BaseDataSource

getUpdateCount() - Method in class org.postgresql.jdbc.BatchResultHandler

getUpdateCount() - Method in class org.postgresql.jdbc.PgStatement

getUpdateCount() - Method in class org.postgresql.jdbc.ResultWrapper

getUrl() - Method in class org.postgresql.ds.common.BaseDataSource

Generates a DriverManager URL from the other properties supplied.

getURL() - Method in class org.postgresql.jdbc.PgConnection

We are required to bring back certain information by the DatabaseMetaData class.

getURL() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getURL(int) - Method in class org.postgresql.jdbc.PgResultSet

getURL(String) - Method in class org.postgresql.jdbc.PgResultSet

getUser() - Method in interface org.postgresql.core.QueryExecutor

getUser() - Method in class org.postgresql.core.QueryExecutorBase

getUser() - Method in class org.postgresql.ds.common.BaseDataSource

Gets the user to connect as by default.

getUserName() - Method in class org.postgresql.jdbc.PgConnection

Method getUserName() brings back the User Name (again, we saved it)

getUserName() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getUseSpNego() - Method in class org.postgresql.ds.common.BaseDataSource

getUUID(String) - Method in class org.postgresql.jdbc.PgResultSet

getUUID(byte[]) - Method in class org.postgresql.jdbc.PgResultSet

getValue() - Method in class org.postgresql.geometric.PGbox

getValue() - Method in class org.postgresql.geometric.PGcircle

getValue() - Method in class org.postgresql.geometric.PGline

getValue() - Method in class org.postgresql.geometric.PGlseg

getValue() - Method in class org.postgresql.geometric.PGpath

This returns the path in the syntax expected by org.postgresql

getValue() - Method in class org.postgresql.geometric.PGpoint

getValue() - Method in class org.postgresql.geometric.PGpolygon

getValue() - Method in class org.postgresql.util.PGInterval

Returns the stored interval information as a string

getValue() - Method in class org.postgresql.util.PGmoney

getValue() - Method in class org.postgresql.util.PGobject

This must be overidden, to return the value of the object, in the form required by org.postgresql.

getValues() - Method in interface org.postgresql.core.ParameterList

Returns the bound parameter values.

getVersion() - Static method in class org.postgresql.Driver

Returns the server version series of this driver and the specific build number.

getVersionColumns(String, String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

getVersionNum() - Method in enum org.postgresql.core.ServerVersion

Get a machine-readable version number.

getVersionNum() - Method in interface org.postgresql.core.Version

Get a machine-readable version number.

getWarning() - Method in interface org.postgresql.core.ResultHandler

Returns the first encountered warning.

getWarning() - Method in class org.postgresql.core.ResultHandlerBase

getWarning() - Method in class org.postgresql.core.ResultHandlerDelegate

getWarnings() - Method in interface org.postgresql.core.QueryExecutor

Retrieve and clear the chain of warnings accumulated on this connection.

getWarnings() - Method in class org.postgresql.core.QueryExecutorBase

getWarnings() - Method in class org.postgresql.jdbc.PgConnection

getWarnings() - Method in class org.postgresql.jdbc.PgResultSet

getWarnings() - Method in class org.postgresql.jdbc.PgStatement

getWhere() - Method in class org.postgresql.util.ServerErrorMessage

getXAConnection() - Method in class org.postgresql.xa.PGXADataSource

Gets a connection to the PostgreSQL database.

getXAConnection(String, String) - Method in class org.postgresql.xa.PGXADataSource

Gets a XA-enabled connection to the PostgreSQL database.

getXAResource() - Method in class org.postgresql.xa.PGXAConnection

getYears() - Method in class org.postgresql.util.PGInterval

Returns the years represented by this interval

GlobalHostStatusTracker - Class in org.postgresql.hostchooser

Keeps track of HostSpec targets in a global map.

GlobalHostStatusTracker() - Constructor for class org.postgresql.hostchooser.GlobalHostStatusTracker

GSSCallbackHandler - Class in org.postgresql.gss

GSSCallbackHandler(String, String) - Constructor for class org.postgresql.gss.GSSCallbackHandler

GT - Class in org.postgresql.util

This class provides a wrapper around a gettext message catalog that can provide a localized version of error messages.

H

handle(Callback[]) - Method in class org.postgresql.gss.GSSCallbackHandler

handleCommandStatus(String, int, long) - Method in interface org.postgresql.core.ResultHandler

Called when a query that did not return a resultset completes.

handleCommandStatus(String, int, long) - Method in class org.postgresql.core.ResultHandlerBase

handleCommandStatus(String, int, long) - Method in class org.postgresql.core.ResultHandlerDelegate

handleCommandStatus(String) - Method in class org.postgresql.core.v3.CopyOperationImpl

handleCommandStatus(String, int, long) - Method in class org.postgresql.jdbc.BatchResultHandler

handleCommandStatus(String, int, long) - Method in class org.postgresql.jdbc.PgResultSet.CursorResultHandler

handleCommandStatus(String, int, long) - Method in class org.postgresql.jdbc.PgStatement.StatementResultHandler

handleCompletion() - Method in interface org.postgresql.core.ResultHandler

Called before a QueryExecutor method returns.

handleCompletion() - Method in class org.postgresql.core.ResultHandlerBase

handleCompletion() - Method in class org.postgresql.core.ResultHandlerDelegate

handleCompletion() - Method in class org.postgresql.jdbc.BatchResultHandler

handleCompletion() - Method in class org.postgresql.jdbc.PgResultSet.CursorResultHandler

handleCompletion() - Method in class org.postgresql.jdbc.PgStatement.StatementResultHandler

handleError(SQLException) - Method in interface org.postgresql.core.ResultHandler

Called when an error occurs.

handleError(SQLException) - Method in class org.postgresql.core.ResultHandlerBase

handleError(SQLException) - Method in class org.postgresql.core.ResultHandlerDelegate

handleError(SQLException) - Method in class org.postgresql.jdbc.BatchResultHandler

handleResultRows(Query, Field[], List<byte[][]>, ResultCursor) - Method in interface org.postgresql.core.ResultHandler

Called when result rows are received from a query.

handleResultRows(Query, Field[], List<byte[][]>, ResultCursor) - Method in class org.postgresql.core.ResultHandlerBase

handleResultRows(Query, Field[], List<byte[][]>, ResultCursor) - Method in class org.postgresql.core.ResultHandlerDelegate

handleResultRows(Query, Field[], List<byte[][]>, ResultCursor) - Method in class org.postgresql.jdbc.BatchResultHandler

handleResultRows(Query, Field[], List<byte[][]>, ResultCursor) - Method in class org.postgresql.jdbc.PgResultSet.CursorResultHandler

handleResultRows(Query, Field[], List<byte[][]>, ResultCursor) - Method in class org.postgresql.jdbc.PgStatement.StatementResultHandler

handleWarning(SQLWarning) - Method in interface org.postgresql.core.ResultHandler

Called when a warning is emitted.

handleWarning(SQLWarning) - Method in class org.postgresql.core.ResultHandlerBase

handleWarning(SQLWarning) - Method in class org.postgresql.core.ResultHandlerDelegate

handleWarning(SQLWarning) - Method in class org.postgresql.jdbc.BatchResultHandler

hasAsciiNumbers() - Method in class org.postgresql.core.Encoding

Returns true if this encoding has characters '-' and '0'..'9' in exactly same posision as ascii.

hasFastDefaultTimeZone() - Method in class org.postgresql.jdbc.TimestampUtils

hashCode() - Method in class org.postgresql.geometric.PGbox

hashCode() - Method in class org.postgresql.geometric.PGcircle

hashCode() - Method in class org.postgresql.geometric.PGline

hashCode() - Method in class org.postgresql.geometric.PGlseg

hashCode() - Method in class org.postgresql.geometric.PGpath

hashCode() - Method in class org.postgresql.geometric.PGpoint

hashCode() - Method in class org.postgresql.geometric.PGpolygon

hashCode() - Method in class org.postgresql.jdbc.FieldMetadata.Key

hashCode() - Method in class org.postgresql.util.HostSpec

hashCode() - Method in class org.postgresql.util.PGInterval

Returns a hashCode for this object

hashCode() - Method in class org.postgresql.util.PGmoney

hashCode() - Method in class org.postgresql.util.PGobject

Compute hash.

hashCode() - Method in class org.postgresql.util.PGTime

hashCode() - Method in class org.postgresql.util.PGTimestamp

hashCode() - Method in class org.postgresql.util.PSQLState

hasMessagePending() - Method in class org.postgresql.core.PGStream

Check for pending backend messages without blocking.

haveMinimumCompatibleVersion(String) - Method in interface org.postgresql.core.BaseConnection

Deprecated. Avoid using this in new code that can require PgJDBC 9.4.

haveMinimumCompatibleVersion(int) - Method in interface org.postgresql.core.BaseConnection

Check if we should use driver behaviour introduced in a particular driver version.

haveMinimumCompatibleVersion(Version) - Method in interface org.postgresql.core.BaseConnection

Check if we should use driver behaviour introduced in a particular driver version.

haveMinimumCompatibleVersion(int) - Method in class org.postgresql.jdbc.PgConnection

haveMinimumCompatibleVersion(String) - Method in class org.postgresql.jdbc.PgConnection

haveMinimumCompatibleVersion(Version) - Method in class org.postgresql.jdbc.PgConnection

haveMinimumServerVersion(String) - Method in interface org.postgresql.core.BaseConnection

Deprecated. Use haveMinimumServerVersion(int) instead

haveMinimumServerVersion(int) - Method in interface org.postgresql.core.BaseConnection

Check if we have at least a particular server version.

haveMinimumServerVersion(Version) - Method in interface org.postgresql.core.BaseConnection

Check if we have at least a particular server version.

haveMinimumServerVersion(String) - Method in class org.postgresql.jdbc.PgConnection

haveMinimumServerVersion(int) - Method in class org.postgresql.jdbc.PgConnection

haveMinimumServerVersion(Version) - Method in class org.postgresql.jdbc.PgConnection

host - Variable in class org.postgresql.util.HostSpec

HostChooser - Interface in org.postgresql.hostchooser

Lists connections in preferred order.

HostChooserFactory - Class in org.postgresql.hostchooser

Chooses a HostChooser instance based on the number of hosts and properties.

HostChooserFactory() - Constructor for class org.postgresql.hostchooser.HostChooserFactory

HostRequirement - Enum in org.postgresql.hostchooser

Describes the required server type.

HostSpec - Class in org.postgresql.util

Simple container for host and port.

HostSpec(String, int) - Constructor for class org.postgresql.util.HostSpec

HostStatus - Enum in org.postgresql.hostchooser

Known state of a server.

HOUR - Static variable in class org.postgresql.jdbc.EscapedFunctions

HStoreConverter - Class in org.postgresql.util

HStoreConverter() - Constructor for class org.postgresql.util.HStoreConverter

I

IFNULL - Static variable in class org.postgresql.jdbc.EscapedFunctions

IN_FAILED_SQL_TRANSACTION - Static variable in class org.postgresql.util.PSQLState

increaseExecuteCount() - Method in class org.postgresql.core.CachedQuery

increaseExecuteCount(int) - Method in class org.postgresql.core.CachedQuery

info(String) - Method in class org.postgresql.core.Logger

info(String, Throwable) - Method in class org.postgresql.core.Logger

INFO - Static variable in class org.postgresql.Driver

initialize() - Method in class org.postgresql.ds.PGPoolingDataSource

Initializes this DataSource.

initializeFrom(BaseDataSource) - Method in class org.postgresql.ds.common.BaseDataSource

INSERT - Static variable in class org.postgresql.jdbc.EscapedFunctions

insertRow() - Method in class org.postgresql.jdbc.PgResultSet

insertsAreDetected(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

instantiate(String, Properties, boolean, String) - Static method in class org.postgresql.util.ObjectFactory

Instantiates a class using the appropriate constructor.

INT2 - Static variable in class org.postgresql.core.Oid

int2(byte[], int) - Static method in class org.postgresql.util.ByteConverter

Parses a short value from the byte array.

int2(byte[], int, int) - Static method in class org.postgresql.util.ByteConverter

Encodes a int value to the byte array.

INT2_ARRAY - Static variable in class org.postgresql.core.Oid

INT4 - Static variable in class org.postgresql.core.Oid

int4(byte[], int) - Static method in class org.postgresql.util.ByteConverter

Parses an int value from the byte array.

int4(byte[], int, int) - Static method in class org.postgresql.util.ByteConverter

Encodes a int value to the byte array.

INT4_ARRAY - Static variable in class org.postgresql.core.Oid

INT8 - Static variable in class org.postgresql.core.Oid

int8(byte[], int) - Static method in class org.postgresql.util.ByteConverter

Parses a long value from the byte array.

int8(byte[], int, long) - Static method in class org.postgresql.util.ByteConverter

Encodes a long value to the byte array.

INT8_ARRAY - Static variable in class org.postgresql.core.Oid

internalGetObject(int, Field) - Method in class org.postgresql.jdbc.PgResultSet

INTERVAL - Static variable in class org.postgresql.core.Oid

INTERVAL_ARRAY - Static variable in class org.postgresql.core.Oid

INVALID_AUTHORIZATION_SPECIFICATION - Static variable in class org.postgresql.util.PSQLState

INVALID_CURSOR_STATE - Static variable in class org.postgresql.util.PSQLState

INVALID_NAME - Static variable in class org.postgresql.util.PSQLState

INVALID_PARAMETER_TYPE - Static variable in class org.postgresql.util.PSQLState

INVALID_PARAMETER_VALUE - Static variable in class org.postgresql.util.PSQLState

INVALID_SAVEPOINT_SPECIFICATION - Static variable in class org.postgresql.util.PSQLState

INVALID_SQL_STATEMENT_NAME - Static variable in class org.postgresql.util.PSQLState

invalidate() - Method in class org.postgresql.jdbc.PSQLSavepoint

IO_ERROR - Static variable in class org.postgresql.util.PSQLState

isActive() - Method in interface org.postgresql.copy.CopyOperation

isActive() - Method in class org.postgresql.copy.PGCopyInputStream

isActive() - Method in class org.postgresql.copy.PGCopyOutputStream

isActive() - Method in class org.postgresql.core.v3.CopyOperationImpl

isAfterLast() - Method in class org.postgresql.jdbc.PgResultSet

isAutoIncrement(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

isBatchedReWriteCompatible() - Method in class org.postgresql.core.SqlCommand

isBeforeFirst() - Method in class org.postgresql.jdbc.PgResultSet

isBinary() - Method in class org.postgresql.jdbc.PgArray

isBinary(int) - Method in class org.postgresql.jdbc.PgResultSet

Returns true if the value of the given column is in binary format.

isCaseSensitive(int) - Method in interface org.postgresql.core.TypeInfo

isCaseSensitive(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

isCaseSensitive(int) - Method in class org.postgresql.jdbc.TypeInfoCache

isCatalogAtStart() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

isClosed() - Method in interface org.postgresql.core.QueryExecutor

Check if this connection is closed.

isClosed() - Method in class org.postgresql.core.QueryExecutorBase

isClosed() - Method in class org.postgresql.geometric.PGpath

isClosed() - Method in class org.postgresql.jdbc.PgConnection

isClosed() - Method in class org.postgresql.jdbc.PgResultSet

isClosed - Variable in class org.postgresql.jdbc.PgStatement

isClosed() - Method in class org.postgresql.jdbc.PgStatement

isCloseOnCompletion() - Method in class org.postgresql.jdbc.PgStatement

isColumnSanitiserDisabled() - Method in interface org.postgresql.core.BaseConnection

Return whether to disable column name sanitation.

isColumnSanitiserDisabled() - Method in interface org.postgresql.core.QueryExecutor

isColumnSanitiserDisabled() - Method in class org.postgresql.core.QueryExecutorBase

isColumnSanitiserDisabled() - Method in class org.postgresql.ds.common.BaseDataSource

isColumnSanitiserDisabled() - Method in class org.postgresql.jdbc.PgConnection

isCurrency(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

isDefaultAutoCommit() - Method in class org.postgresql.ds.PGConnectionPoolDataSource

Gets whether connections supplied by this pool will have autoCommit turned on by default.

isDefinitelyWritable(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

isDollarQuoteContChar(char) - Static method in class org.postgresql.core.Parser

Checks if a character is valid as the second or later character of a dollar quoting tag.

isDollarQuoteStartChar(char) - Static method in class org.postgresql.core.Parser

Checks if a character is valid as the start of a dollar quoting tag.

isEmpty() - Method in interface org.postgresql.core.Query

isFirst() - Method in class org.postgresql.jdbc.PgResultSet

isFlushCacheOnDeallocate() - Method in class org.postgresql.core.QueryExecutorBase

isFunction - Variable in class org.postgresql.core.CachedQuery

isFunction() - Method in class org.postgresql.core.JdbcCallParseInfo

Returns if given SQL is a function

isIdentifierContChar(char) - Static method in class org.postgresql.core.Parser

Checks if a character is valid as the second or later character of an identifier.

isIdentifierStartChar(char) - Static method in class org.postgresql.core.Parser

Checks if a character is valid as the start of an identifier.

isInitialized() - Method in class org.postgresql.ds.PGPoolingDataSource

isLast() - Method in class org.postgresql.jdbc.PgResultSet

isNullable(int) - Method in class org.postgresql.jdbc.PgParameterMetaData

isNullable(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

isOneShotQuery(CachedQuery) - Method in class org.postgresql.jdbc.PgStatement

Returns true if query is unlikely to be reused

isOpen() - Method in class org.postgresql.geometric.PGpath

isOperatorChar(char) - Static method in class org.postgresql.core.Parser

isOutParmBeforeFunc() - Method in class org.postgresql.core.JdbcCallParseInfo

Returns if given SQL is a function with one out parameter

isPoolable() - Method in class org.postgresql.jdbc.PgStatement

isPresent(Properties) - Method in enum org.postgresql.PGProperty

Test whether this property is present in the given Properties

isReadOnly() - Method in class org.postgresql.jdbc.PgConnection

isReadOnly() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

isReadOnly(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

isRegistered() - Static method in class org.postgresql.Driver

isResultSetClosed() - Method in class org.postgresql.jdbc.PgResultSet

isReturningKeywordPresent() - Method in class org.postgresql.core.SqlCommand

isReWriteBatchedInsertsEnabled() - Method in interface org.postgresql.core.QueryExecutor

isReWriteBatchedInsertsEnabled() - Method in class org.postgresql.core.QueryExecutorBase

isSameRM(XAResource) - Method in class org.postgresql.xa.PGXAConnection

isSearchable(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

isSigned(int) - Method in interface org.postgresql.core.TypeInfo

isSigned(int) - Method in class org.postgresql.jdbc.PgParameterMetaData

PostgreSQL doesn't have unsigned numbers

isSigned(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

isSigned(int) - Method in class org.postgresql.jdbc.TypeInfoCache

isSpace(char) - Static method in class org.postgresql.core.Parser

ISSPIClient - Interface in org.postgresql.sspi

Use Waffle-JNI to support SSPI authentication when PgJDBC is running on a Windows client and talking to a Windows server.

isSSPISupported() - Method in interface org.postgresql.sspi.ISSPIClient

isSSPISupported() - Method in class org.postgresql.sspi.SSPIClient

Test whether we can attempt SSPI authentication.

isStatementDescribed() - Method in interface org.postgresql.core.Query

isTypeInitialized() - Method in class org.postgresql.core.Field

isUseServerPrepare() - Method in class org.postgresql.jdbc.PgStatement

isUseServerPrepare() - Method in interface org.postgresql.PGStatement

Checks if this statement will be executed as a server-prepared statement.

isValid(int) - Method in class org.postgresql.jdbc.PgConnection

isWrapperFor(Class<?>) - Method in class org.postgresql.ds.PGPoolingDataSource

isWrapperFor(Class<?>) - Method in class org.postgresql.ds.PGSimpleDataSource

isWrapperFor(Class<?>) - Method in class org.postgresql.jdbc.PgConnection

isWrapperFor(Class<?>) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

isWrapperFor(Class<?>) - Method in class org.postgresql.jdbc.PgParameterMetaData

isWrapperFor(Class<?>) - Method in class org.postgresql.jdbc.PgResultSet

isWrapperFor(Class<?>) - Method in class org.postgresql.jdbc.PgResultSetMetaData

isWrapperFor(Class<?>) - Method in class org.postgresql.jdbc.PgStatement

isWritable(int) - Method in class org.postgresql.jdbc.PgResultSetMetaData

iterator() - Method in interface org.postgresql.hostchooser.HostChooser

Lists connection hosts in preferred order.

iterator() - Method in class org.postgresql.hostchooser.MultiHostChooser

iterator() - Method in class org.postgresql.hostchooser.SingleHostChooser

J

Jdbc3ConnectionPool - Class in org.postgresql.jdbc3

Jdbc3ConnectionPool() - Constructor for class org.postgresql.jdbc3.Jdbc3ConnectionPool

Jdbc3PoolingDataSource - Class in org.postgresql.jdbc3

Jdbc3PoolingDataSource() - Constructor for class org.postgresql.jdbc3.Jdbc3PoolingDataSource

Jdbc3SimpleDataSource - Class in org.postgresql.jdbc3

Jdbc3SimpleDataSource() - Constructor for class org.postgresql.jdbc3.Jdbc3SimpleDataSource

JdbcBlackHole - Class in org.postgresql.util

JdbcBlackHole() - Constructor for class org.postgresql.util.JdbcBlackHole

JdbcCallParseInfo - Class in org.postgresql.core

Contains parse flags from Parser.modifyJdbcCall(String, boolean, int, int).

JdbcCallParseInfo(String, boolean, boolean) - Constructor for class org.postgresql.core.JdbcCallParseInfo

jdbcCompliant() - Method in class org.postgresql.Driver

Report whether the driver is a genuine JDBC compliant driver.

JSON - Static variable in class org.postgresql.core.Oid

JSON_ARRAY - Static variable in class org.postgresql.core.Oid

JSONB_ARRAY - Static variable in class org.postgresql.core.Oid

K

key - Variable in class org.postgresql.core.CachedQuery

Cache key.

Keyword - Enum in org.postgresql.core

Reserved SQL keywords.

L

LargeObject - Class in org.postgresql.largeobject

This class provides the basic methods required to run the interface, plus a pair of methods that provide InputStream and OutputStream classes for this object.

LargeObject(Fastpath, long, int, BaseConnection, boolean) - Constructor for class org.postgresql.largeobject.LargeObject

This opens a large object.

LargeObject(Fastpath, long, int) - Constructor for class org.postgresql.largeobject.LargeObject

This opens a large object.

LargeObjectManager - Class in org.postgresql.largeobject

This class implements the large object interface to org.postgresql.

LargeObjectManager(BaseConnection) - Constructor for class org.postgresql.largeobject.LargeObjectManager

Constructs the LargeObject API.

last() - Method in class org.postgresql.jdbc.PgResultSet

lastWarning - Variable in class org.postgresql.jdbc.PgStatement

The last warning of the warning chain.

LazyKeyManager - Class in org.postgresql.ssl.jdbc4

A Key manager that only loads the keys, if necessary.

LazyKeyManager(String, String, CallbackHandler, boolean) - Constructor for class org.postgresql.ssl.jdbc4.LazyKeyManager

Constructor. certfile and keyfile can be null, in that case no certificate is presented to the server.

LCASE - Static variable in class org.postgresql.jdbc.EscapedFunctions

LEFT - Static variable in class org.postgresql.jdbc.EscapedFunctions

length() - Method in class org.postgresql.jdbc.AbstractBlobClob

LENGTH - Static variable in class org.postgresql.jdbc.EscapedFunctions

lengthInBytes() - Method in class org.postgresql.geometric.PGbox

lengthInBytes() - Method in class org.postgresql.geometric.PGpoint

lengthInBytes() - Method in interface org.postgresql.util.PGBinaryObject

This method is called to return the number of bytes needed to store this object in the binary form required by org.postgresql.

LibPQFactory - Class in org.postgresql.ssl.jdbc4

Provide an SSLSocketFactory that is compatible with the libpq behaviour.

LibPQFactory(Properties) - Constructor for class org.postgresql.ssl.jdbc4.LibPQFactory

loadBaseDataSource(BaseDataSource, Reference) - Method in class org.postgresql.ds.common.PGObjectFactory

LOCATE - Static variable in class org.postgresql.jdbc.EscapedFunctions

locatorsUpdateCopy() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

log(String, Throwable) - Method in class org.postgresql.core.Logger

LOG - Static variable in class org.postgresql.jdbc.EscapedFunctions

LOG10 - Static variable in class org.postgresql.jdbc.EscapedFunctions

logDebug() - Method in class org.postgresql.core.Logger

Logger - Class in org.postgresql.core

Poor man's logging infrastructure.

Logger() - Constructor for class org.postgresql.core.Logger

Logger(int) - Constructor for class org.postgresql.core.Logger

logger - Variable in class org.postgresql.core.QueryExecutorBase

logInfo() - Method in class org.postgresql.core.Logger

LruCache<Key,Value extends CanEstimateSize> - Class in org.postgresql.util

Caches values in simple least-recently-accessed order.

LruCache(int, long, boolean) - Constructor for class org.postgresql.util.LruCache

LruCache(int, long, boolean, LruCache.CreateAction<Key, Value>, LruCache.EvictAction<Value>) - Constructor for class org.postgresql.util.LruCache

LruCache.CreateAction<Key,Value> - Interface in org.postgresql.util

When the entry is not present in cache, this create action is used to create one.

LruCache.EvictAction<Value> - Interface in org.postgresql.util

Action that is invoked when the entry is removed from the cache.

LTRIM - Static variable in class org.postgresql.jdbc.EscapedFunctions

M

m_prepareThreshold - Variable in class org.postgresql.jdbc.PgStatement

main(String[]) - Static method in class org.postgresql.util.PGJDBCMain

main(String[]) - Static method in class org.postgresql.util.PSQLDriverVersion

MAJORVERSION - Static variable in class org.postgresql.Driver

makeArray(int, String) - Method in class org.postgresql.jdbc.PgConnection

makeArray(int, byte[]) - Method in class org.postgresql.jdbc.PgResultSet

makeArray(int, String) - Method in class org.postgresql.jdbc.PgResultSet

makeBlob(long) - Method in class org.postgresql.jdbc.PgConnection

makeBlob(long) - Method in class org.postgresql.jdbc.PgResultSet

makeClob(long) - Method in class org.postgresql.jdbc.PgConnection

makeClob(long) - Method in class org.postgresql.jdbc.PgResultSet

MakeGSS - Class in org.postgresql.gss

MakeGSS() - Constructor for class org.postgresql.gss.MakeGSS

makeSQLXML() - Method in class org.postgresql.jdbc.PgConnection

MakeSSL - Class in org.postgresql.ssl

MakeSSL() - Constructor for class org.postgresql.ssl.MakeSSL

mark(int) - Method in class org.postgresql.largeobject.BlobInputStream

Marks the current position in this input stream.

markSupported() - Method in class org.postgresql.largeobject.BlobInputStream

Tests if this input stream supports the mark and reset methods.

maxFieldSize - Variable in class org.postgresql.jdbc.PgResultSet

maxfieldSize - Variable in class org.postgresql.jdbc.PgStatement

maxRows - Variable in class org.postgresql.jdbc.PgResultSet

maxrows - Variable in class org.postgresql.jdbc.PgStatement

Maximum number of rows to return, 0 = unlimited

MD5Digest - Class in org.postgresql.util

metadata - Variable in class org.postgresql.jdbc.PgConnection

MINORVERSION - Static variable in class org.postgresql.Driver

MINUTE - Static variable in class org.postgresql.jdbc.EscapedFunctions

MOD - Static variable in class org.postgresql.jdbc.EscapedFunctions

modifyJdbcCall(String, boolean, int, int) - Static method in class org.postgresql.core.Parser

Converts JDBC-specific callable statement escapes {@code { [?

MONEY - Static variable in class org.postgresql.core.Oid

MONEY_ARRAY - Static variable in class org.postgresql.core.Oid

MONTH - Static variable in class org.postgresql.jdbc.EscapedFunctions

MONTHNAME - Static variable in class org.postgresql.jdbc.EscapedFunctions

MOST_SPECIFIC_TYPE_DOES_NOT_MATCH - Static variable in class org.postgresql.util.PSQLState

move(int, int) - Method in class org.postgresql.geometric.PGpoint

Moves the point to the supplied coordinates.

move(double, double) - Method in class org.postgresql.geometric.PGpoint

Moves the point to the supplied coordinates.

moveToCurrentRow() - Method in class org.postgresql.jdbc.PgResultSet

moveToInsertRow() - Method in class org.postgresql.jdbc.PgResultSet

MultiHostChooser - Class in org.postgresql.hostchooser

HostChooser that keeps track of known host statuses.

MultiHostChooser(HostSpec[], HostRequirement, Properties) - Constructor for class org.postgresql.hostchooser.MultiHostChooser

multiStatement - Variable in class org.postgresql.core.NativeQuery

N

name() - Method in class org.postgresql.core.Encoding

Get the name of the (JVM) encoding used.

NAME - Static variable in class org.postgresql.core.Oid

NAME_ARRAY - Static variable in class org.postgresql.core.Oid

NativeQuery - Class in org.postgresql.core

Represents a query that is ready for execution by backend.

NativeQuery(String, SqlCommand) - Constructor for class org.postgresql.core.NativeQuery

NativeQuery(String, int[], boolean, SqlCommand) - Constructor for class org.postgresql.core.NativeQuery

nativeSql - Variable in class org.postgresql.core.NativeQuery

nativeSQL(String) - Method in class org.postgresql.jdbc.PgConnection

next() - Method in class org.postgresql.jdbc.PgResultSet

NO_ACTIVE_SQL_TRANSACTION - Static variable in class org.postgresql.util.PSQLState

NO_DATA - Static variable in class org.postgresql.util.PSQLState

NO_OPTIONS - Static variable in class org.postgresql.util.Base64

No options specified.

NonValidatingFactory - Class in org.postgresql.ssl

Provide a SSLSocketFactory that allows SSL connections to be made without validating the server's certificate.

NonValidatingFactory(String) - Constructor for class org.postgresql.ssl.NonValidatingFactory

We provide a constructor that takes an unused argument solely because the ssl calling code will look for this constructor first and then fall back to the no argument constructor, so we avoid an exception and additional reflection lookups.

NonValidatingFactory.NonValidatingTM - Class in org.postgresql.ssl

NonValidatingFactory.NonValidatingTM() - Constructor for class org.postgresql.ssl.NonValidatingFactory.NonValidatingTM

NOOP_CREATE_ACTION - Static variable in class org.postgresql.util.LruCache

NOOP_EVICT_ACTION - Static variable in class org.postgresql.util.LruCache

NOT_IMPLEMENTED - Static variable in class org.postgresql.util.PSQLState

Notification - Class in org.postgresql.core

Notification(String, int) - Constructor for class org.postgresql.core.Notification

Notification(String, int, String) - Constructor for class org.postgresql.core.Notification

notImplemented(Class<?>, String) - Static method in class org.postgresql.Driver

This method was added in v6.5, and simply throws an SQLException for an unimplemented method.

NOW - Static variable in class org.postgresql.jdbc.EscapedFunctions

NTDSAPIWrapper - Class in org.postgresql.sspi

NTDSAPIWrapper() - Constructor for class org.postgresql.sspi.NTDSAPIWrapper

nullPlusNonNullIsNull() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

nullsAreSortedAtEnd() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

nullsAreSortedAtStart() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

nullsAreSortedHigh() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

nullsAreSortedLow() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

NUMERIC - Static variable in class org.postgresql.core.Oid

NUMERIC_ARRAY - Static variable in class org.postgresql.core.Oid

NUMERIC_CONSTANT_OUT_OF_RANGE - Static variable in class org.postgresql.util.PSQLState

NUMERIC_VALUE_OUT_OF_RANGE - Static variable in class org.postgresql.util.PSQLState

O

OBJECT_NOT_IN_STATE - Static variable in class org.postgresql.util.PSQLState

ObjectFactory - Class in org.postgresql.util

Helper class to instantiate objects.

ObjectFactory() - Constructor for class org.postgresql.util.ObjectFactory

of(String) - Static method in enum org.postgresql.jdbc.AutoSave

of(String) - Static method in enum org.postgresql.jdbc.PreferQueryMode

OFF - Static variable in class org.postgresql.Driver

Oid - Class in org.postgresql.core

Provides constants for well-known backend OIDs for the types we commonly use.

Oid() - Constructor for class org.postgresql.core.Oid

OID - Static variable in class org.postgresql.core.Oid

OID_ARRAY - Static variable in class org.postgresql.core.Oid

onInsertRow - Variable in class org.postgresql.jdbc.PgResultSet

open - Variable in class org.postgresql.geometric.PGpath

True if the path is open, false if closed

open(int) - Method in class org.postgresql.largeobject.LargeObjectManager

Deprecated. As of 8.3, replaced by LargeObjectManager.open(long)

open(int, boolean) - Method in class org.postgresql.largeobject.LargeObjectManager

This opens an existing large object, same as previous method, but commits the transaction on close if asked.

open(long) - Method in class org.postgresql.largeobject.LargeObjectManager

This opens an existing large object, based on its OID.

open(long, boolean) - Method in class org.postgresql.largeobject.LargeObjectManager

This opens an existing large object, same as previous method, but commits the transaction on close if asked

open(int, int) - Method in class org.postgresql.largeobject.LargeObjectManager

Deprecated. As of 8.3, replaced by LargeObjectManager.open(long, int)

open(int, int, boolean) - Method in class org.postgresql.largeobject.LargeObjectManager

This opens an existing large object, same as previous method, but commits the transaction on close if asked

open(long, int) - Method in class org.postgresql.largeobject.LargeObjectManager

This opens an existing large object, based on its OID

open(long, int, boolean) - Method in class org.postgresql.largeobject.LargeObjectManager

This opens an existing large object, based on its OID

openConnection(HostSpec[], String, String, Properties, Logger) - Static method in class org.postgresql.core.ConnectionFactory

Establishes and initializes a new connection.

openConnectionImpl(HostSpec[], String, String, Properties, Logger) - Method in class org.postgresql.core.ConnectionFactory

Implementation of ConnectionFactory.openConnection(org.postgresql.util.HostSpec[], java.lang.String, java.lang.String, java.util.Properties, org.postgresql.core.Logger) for a particular protocol version.

openConnectionImpl(HostSpec[], String, String, Properties, Logger) - Method in class org.postgresql.core.v3.ConnectionFactoryImpl

openPath() - Method in class org.postgresql.geometric.PGpath

org.postgresql - package org.postgresql

org.postgresql.copy - package org.postgresql.copy

org.postgresql.core - package org.postgresql.core

org.postgresql.core.v3 - package org.postgresql.core.v3

org.postgresql.ds - package org.postgresql.ds

org.postgresql.ds.common - package org.postgresql.ds.common

org.postgresql.fastpath - package org.postgresql.fastpath

org.postgresql.geometric - package org.postgresql.geometric

org.postgresql.gss - package org.postgresql.gss

org.postgresql.hostchooser - package org.postgresql.hostchooser

org.postgresql.jdbc - package org.postgresql.jdbc

org.postgresql.jdbc2 - package org.postgresql.jdbc2

org.postgresql.jdbc2.optional - package org.postgresql.jdbc2.optional

org.postgresql.jdbc3 - package org.postgresql.jdbc3

org.postgresql.largeobject - package org.postgresql.largeobject

org.postgresql.osgi - package org.postgresql.osgi

org.postgresql.ssl - package org.postgresql.ssl

org.postgresql.ssl.jdbc4 - package org.postgresql.ssl.jdbc4

org.postgresql.sspi - package org.postgresql.sspi

org.postgresql.util - package org.postgresql.util

org.postgresql.xa - package org.postgresql.xa

originalQuery - Variable in class org.postgresql.jdbc.PgResultSet

othersDeletesAreVisible(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

othersInsertsAreVisible(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

othersUpdatesAreVisible(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

OUT_OF_MEMORY - Static variable in class org.postgresql.util.PSQLState

outParmBeforeFunc - Variable in class org.postgresql.core.CachedQuery

ownDeletesAreVisible(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

ownInsertsAreVisible(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

ownUpdatesAreVisible(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

P

ParameterList - Interface in org.postgresql.core

Abstraction of a list of parameters to be substituted into a Query.

parseACL(String, String) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Take the a String representing an array of ACLs and return a Map mapping the SQL permission name to a List of usernames who have that permission.

parseBackendTimeZone(String) - Static method in class org.postgresql.jdbc.TimestampUtils

Converts backend's TimeZone parameter to java format.

parseBlockComment(char[], int) - Static method in class org.postgresql.core.Parser

Test if the / character at offset starts a block comment, and return the position of the last / character.

parseDeleteKeyword(char[], int) - Static method in class org.postgresql.core.Parser

Parse string to check presence of DELETE keyword regardless of case.

parseDollarQuotes(char[], int) - Static method in class org.postgresql.core.Parser

Test if the dollar character ($) at the given offset starts a dollar-quoted string and return the offset of the ending dollar character.

parseDoubleQuotes(char[], int) - Static method in class org.postgresql.core.Parser

Find the end of the double-quoted string starting at the given offset.

parseInsertKeyword(char[], int) - Static method in class org.postgresql.core.Parser

Parse string to check presence of INSERT keyword regardless of case.

parseJdbcSql(String, boolean, boolean, boolean, boolean, String...) - Static method in class org.postgresql.core.Parser

Parses JDBC query into PostgreSQL's native format.

parseLineComment(char[], int) - Static method in class org.postgresql.core.Parser

Test if the - character at offset starts a -- style line comment, and return the position of the first \r or \n character.

parseMoveKeyword(char[], int) - Static method in class org.postgresql.core.Parser

Parse string to check presence of MOVE keyword regardless of case.

Parser - Class in org.postgresql.core

Basic query parser infrastructure.

Parser() - Constructor for class org.postgresql.core.Parser

parseReturningKeyword(char[], int) - Static method in class org.postgresql.core.Parser

Parse string to check presence of RETURNING keyword regardless of case.

parseSelectKeyword(char[], int) - Static method in class org.postgresql.core.Parser

Parse string to check presence of SELECT keyword regardless of case.

parseServerVersionStr(String) - Static method in class org.postgresql.core.Utils

Deprecated. use specific Version instance

parseSingleQuotes(char[], int, boolean) - Static method in class org.postgresql.core.Parser

Find the end of the single-quoted string starting at the given offset.

parseUpdateKeyword(char[], int) - Static method in class org.postgresql.core.Parser

Parse string to check presence of UPDATE keyword regardless of case.

parseURL(String, Properties) - Static method in class org.postgresql.Driver

Constructs a new DriverURL, splitting the specified URL into its component parts

parseValuesKeyword(char[], int) - Static method in class org.postgresql.core.Parser

Parse string to check presence of VALUES keyword regardless of case.

parseWithKeyword(char[], int) - Static method in class org.postgresql.core.Parser

Parse string to check presence of WITH keyword regardless of case.

peek() - Method in class org.postgresql.core.VisibleBufferedInputStream

Reads a byte from the buffer without advancing the index pointer.

peekChar() - Method in class org.postgresql.core.PGStream

Receives a single character from the backend, without advancing the current protocol stream position.

PgArray - Class in org.postgresql.jdbc

Array is used collect one column of query result data.

PgArray(BaseConnection, int, String) - Constructor for class org.postgresql.jdbc.PgArray

Create a new Array.

PgArray(BaseConnection, int, byte[]) - Constructor for class org.postgresql.jdbc.PgArray

Create a new Array.

PGBinaryObject - Interface in org.postgresql.util

PGBinaryObject is a inteface that classes extending PGobject can use to take advantage of more optimal binary encoding of the data type.

PGBindException - Exception in org.postgresql.core

PGBindException(IOException) - Constructor for exception org.postgresql.core.PGBindException

PgBlob - Class in org.postgresql.jdbc

PgBlob(BaseConnection, long) - Constructor for class org.postgresql.jdbc.PgBlob

PGbox - Class in org.postgresql.geometric

This represents the box datatype within org.postgresql.

PGbox(double, double, double, double) - Constructor for class org.postgresql.geometric.PGbox

PGbox(PGpoint, PGpoint) - Constructor for class org.postgresql.geometric.PGbox

PGbox(String) - Constructor for class org.postgresql.geometric.PGbox

PGbox() - Constructor for class org.postgresql.geometric.PGbox

Required constructor

PGBundleActivator - Class in org.postgresql.osgi

This class is an OSGi Bundle Activator and should only be used internally by the OSGi Framework

PGBundleActivator() - Constructor for class org.postgresql.osgi.PGBundleActivator

PGbytea - Class in org.postgresql.util

Converts to and from the postgresql bytea datatype used by the backend.

PGbytea() - Constructor for class org.postgresql.util.PGbytea

PGcircle - Class in org.postgresql.geometric

This represents org.postgresql's circle datatype, consisting of a point and a radius

PGcircle(double, double, double) - Constructor for class org.postgresql.geometric.PGcircle

PGcircle(PGpoint, double) - Constructor for class org.postgresql.geometric.PGcircle

PGcircle(String) - Constructor for class org.postgresql.geometric.PGcircle

PGcircle() - Constructor for class org.postgresql.geometric.PGcircle

This constructor is used by the driver.

PgClob - Class in org.postgresql.jdbc

PgClob(BaseConnection, long) - Constructor for class org.postgresql.jdbc.PgClob

PgConnection - Class in org.postgresql.jdbc

PgConnection(HostSpec[], String, String, Properties, String) - Constructor for class org.postgresql.jdbc.PgConnection

PGConnection - Interface in org.postgresql

This interface defines the public PostgreSQL extensions to java.sql.Connection.

PgConnection.AbortCommand - Class in org.postgresql.jdbc

PgConnection.AbortCommand() - Constructor for class org.postgresql.jdbc.PgConnection.AbortCommand

PGConnectionPoolDataSource - Class in org.postgresql.ds

PostgreSQL implementation of ConnectionPoolDataSource.

PGConnectionPoolDataSource() - Constructor for class org.postgresql.ds.PGConnectionPoolDataSource

PGCopyInputStream - Class in org.postgresql.copy

InputStream for reading from a PostgreSQL COPY TO STDOUT operation

PGCopyInputStream(PGConnection, String) - Constructor for class org.postgresql.copy.PGCopyInputStream

Uses given connection for specified COPY TO STDOUT operation

PGCopyInputStream(CopyOut) - Constructor for class org.postgresql.copy.PGCopyInputStream

Use given CopyOut operation for reading

PGCopyOutputStream - Class in org.postgresql.copy

OutputStream for buffered input into a PostgreSQL COPY FROM STDIN operation

PGCopyOutputStream(PGConnection, String) - Constructor for class org.postgresql.copy.PGCopyOutputStream

Uses given connection for specified COPY FROM STDIN operation

PGCopyOutputStream(PGConnection, String, int) - Constructor for class org.postgresql.copy.PGCopyOutputStream

Uses given connection for specified COPY FROM STDIN operation

PGCopyOutputStream(CopyIn) - Constructor for class org.postgresql.copy.PGCopyOutputStream

Use given CopyIn operation for writing

PGCopyOutputStream(CopyIn, int) - Constructor for class org.postgresql.copy.PGCopyOutputStream

Use given CopyIn operation for writing

PgDatabaseMetaData - Class in org.postgresql.jdbc

PgDatabaseMetaData(PgConnection) - Constructor for class org.postgresql.jdbc.PgDatabaseMetaData

PGDataSourceFactory - Class in org.postgresql.osgi

This factory service is designed to be used in OSGi Enterprise environments to create and configure JDBC data-sources.

PGDataSourceFactory() - Constructor for class org.postgresql.osgi.PGDataSourceFactory

PGInterval - Class in org.postgresql.util

This implements a class that handles the PostgreSQL interval type

PGInterval() - Constructor for class org.postgresql.util.PGInterval

required by the driver

PGInterval(String) - Constructor for class org.postgresql.util.PGInterval

Initialize a interval with a given interval string representation

PGInterval(int, int, int, int, int, double) - Constructor for class org.postgresql.util.PGInterval

Initializes all values of this interval to the specified values

PGJDBCMain - Class in org.postgresql.util

PGJDBCMain() - Constructor for class org.postgresql.util.PGJDBCMain

PGline - Class in org.postgresql.geometric

This implements a line represented by the linear equation Ax + By + C = 0

PGline(double, double, double) - Constructor for class org.postgresql.geometric.PGline

PGline(double, double, double, double) - Constructor for class org.postgresql.geometric.PGline

PGline(PGpoint, PGpoint) - Constructor for class org.postgresql.geometric.PGline

PGline(PGlseg) - Constructor for class org.postgresql.geometric.PGline

PGline(String) - Constructor for class org.postgresql.geometric.PGline

PGline() - Constructor for class org.postgresql.geometric.PGline

required by the driver

PGlseg - Class in org.postgresql.geometric

This implements a lseg (line segment) consisting of two points

PGlseg(double, double, double, double) - Constructor for class org.postgresql.geometric.PGlseg

PGlseg(PGpoint, PGpoint) - Constructor for class org.postgresql.geometric.PGlseg

PGlseg(String) - Constructor for class org.postgresql.geometric.PGlseg

PGlseg() - Constructor for class org.postgresql.geometric.PGlseg

reuired by the driver

PGmoney - Class in org.postgresql.util

This implements a class that handles the PostgreSQL money and cash types

PGmoney(double) - Constructor for class org.postgresql.util.PGmoney

PGmoney(String) - Constructor for class org.postgresql.util.PGmoney

PGmoney() - Constructor for class org.postgresql.util.PGmoney

PGNotification - Interface in org.postgresql

This interface defines the public PostgreSQL extension for Notifications

PGobject - Class in org.postgresql.util

PGobject is a class used to describe unknown types An unknown type is any type that is unknown by JDBC Standards

PGobject() - Constructor for class org.postgresql.util.PGobject

This is called by org.postgresql.Connection.getObject() to create the object.

PGObjectFactory - Class in org.postgresql.ds.common

Returns a DataSource-ish thing based on a JNDI reference.

PGObjectFactory() - Constructor for class org.postgresql.ds.common.PGObjectFactory

PgParameterMetaData - Class in org.postgresql.jdbc

PgParameterMetaData(BaseConnection, int[]) - Constructor for class org.postgresql.jdbc.PgParameterMetaData

PGpath - Class in org.postgresql.geometric

This implements a path (a multiple segmented line, which may be closed)

PGpath(PGpoint[], boolean) - Constructor for class org.postgresql.geometric.PGpath

PGpath() - Constructor for class org.postgresql.geometric.PGpath

Required by the driver

PGpath(String) - Constructor for class org.postgresql.geometric.PGpath

PGpoint - Class in org.postgresql.geometric

It maps to the point datatype in org.postgresql.

PGpoint(double, double) - Constructor for class org.postgresql.geometric.PGpoint

PGpoint(String) - Constructor for class org.postgresql.geometric.PGpoint

This is called mainly from the other geometric types, when a point is embedded within their definition.

PGpoint() - Constructor for class org.postgresql.geometric.PGpoint

Required by the driver

PGpolygon - Class in org.postgresql.geometric

This implements the polygon datatype within PostgreSQL.

PGpolygon(PGpoint[]) - Constructor for class org.postgresql.geometric.PGpolygon

Creates a polygon using an array of PGpoints

PGpolygon(String) - Constructor for class org.postgresql.geometric.PGpolygon

PGpolygon() - Constructor for class org.postgresql.geometric.PGpolygon

Required by the driver

PGPooledConnection - Class in org.postgresql.ds

PostgreSQL implementation of the PooledConnection interface.

PGPooledConnection(Connection, boolean, boolean) - Constructor for class org.postgresql.ds.PGPooledConnection

Creates a new PooledConnection representing the specified physical connection.

PGPooledConnection(Connection, boolean) - Constructor for class org.postgresql.ds.PGPooledConnection

PGPoolingDataSource - Class in org.postgresql.ds

DataSource which uses connection pooling.

PGPoolingDataSource() - Constructor for class org.postgresql.ds.PGPoolingDataSource

PGProperty - Enum in org.postgresql

All connection parameters that can be either set in JDBC URL, in Driver properties or in datasource setters.

PGRefCursorResultSet - Interface in org.postgresql

Deprecated. As of 8.0, this interface is only present for backwards- compatibility purposes. New code should call getString() on the ResultSet that contains the refcursor to obtain the underlying cursor name.

PgResultSet - Class in org.postgresql.jdbc

PgResultSet.CursorResultHandler - Class in org.postgresql.jdbc

PgResultSet.CursorResultHandler() - Constructor for class org.postgresql.jdbc.PgResultSet.CursorResultHandler

PgResultSetMetaData - Class in org.postgresql.jdbc

PgResultSetMetaData(BaseConnection, Field[]) - Constructor for class org.postgresql.jdbc.PgResultSetMetaData

PGResultSetMetaData - Interface in org.postgresql

PGSimpleDataSource - Class in org.postgresql.ds

Simple DataSource which does not perform connection pooling.

PGSimpleDataSource() - Constructor for class org.postgresql.ds.PGSimpleDataSource

PgSQLXML - Class in org.postgresql.jdbc

PgSQLXML(BaseConnection) - Constructor for class org.postgresql.jdbc.PgSQLXML

PgSQLXML(BaseConnection, String) - Constructor for class org.postgresql.jdbc.PgSQLXML

PgStatement - Class in org.postgresql.jdbc

PGStatement - Interface in org.postgresql

This interface defines the public PostgreSQL extensions to java.sql.Statement.

PgStatement.StatementResultHandler - Class in org.postgresql.jdbc

ResultHandler implementations for updates, queries, and either-or.

PgStatement.StatementResultHandler() - Constructor for class org.postgresql.jdbc.PgStatement.StatementResultHandler

PGStream - Class in org.postgresql.core

Wrapper around the raw connection to the server that implements some basic primitives (reading/writing formatted data, doing string encoding, etc).

PGStream(SocketFactory, HostSpec, int) - Constructor for class org.postgresql.core.PGStream

Constructor: Connect to the PostgreSQL back end and return a stream connection.

PGStream(SocketFactory, HostSpec) - Constructor for class org.postgresql.core.PGStream

Deprecated. use PGStream.PGStream(SocketFactory, org.postgresql.util.HostSpec, int)

pgStream - Variable in class org.postgresql.core.QueryExecutorBase

PGTime - Class in org.postgresql.util

This class augments the Java built-in Time to allow for explicit setting of the time zone.

PGTime(long) - Constructor for class org.postgresql.util.PGTime

Constructs a PGTime without a time zone.

PGTime(long, Calendar) - Constructor for class org.postgresql.util.PGTime

Constructs a PGTime with the given calendar object.

PGTimestamp - Class in org.postgresql.util

This class augments the Java built-in Timestamp to allow for explicit setting of the time zone.

PGTimestamp(long) - Constructor for class org.postgresql.util.PGTimestamp

Constructs a PGTimestamp without a time zone.

PGTimestamp(long, Calendar) - Constructor for class org.postgresql.util.PGTimestamp

Constructs a PGTimestamp with the given time zone.

PGtokenizer - Class in org.postgresql.util

This class is used to tokenize the text output of org.postgres.

PGtokenizer(String, char) - Constructor for class org.postgresql.util.PGtokenizer

Create a tokeniser.

PGXAConnection - Class in org.postgresql.xa

The PostgreSQL implementation of XAResource.

PGXAConnection(BaseConnection) - Constructor for class org.postgresql.xa.PGXAConnection

PGXADataSource - Class in org.postgresql.xa

XA-enabled DataSource implementation.

PGXADataSource() - Constructor for class org.postgresql.xa.PGXADataSource

PGXADataSourceFactory - Class in org.postgresql.xa

An ObjectFactory implementation for PGXADataSource-objects.

PGXADataSourceFactory() - Constructor for class org.postgresql.xa.PGXADataSourceFactory

PGXAException - Exception in org.postgresql.xa

A convenience subclass of XAException which makes it easy to create an instance of XAException with a human-readable message, a Throwable cause, and an XA error code.

PI - Static variable in class org.postgresql.jdbc.EscapedFunctions

POINT - Static variable in class org.postgresql.core.Oid

point - Variable in class org.postgresql.geometric.PGbox

These are the two points.

point - Variable in class org.postgresql.geometric.PGlseg

These are the two points.

POINT_ARRAY - Static variable in class org.postgresql.core.Oid

points - Variable in class org.postgresql.geometric.PGpath

The points defining this path

points - Variable in class org.postgresql.geometric.PGpolygon

The points defining the polygon

PoolingDataSource - Class in org.postgresql.jdbc2.optional

PoolingDataSource() - Constructor for class org.postgresql.jdbc2.optional.PoolingDataSource

port - Variable in class org.postgresql.util.HostSpec

position(byte[], long) - Method in class org.postgresql.jdbc.AbstractBlobClob

Iterate over the buffer looking for the specified pattern

position(Blob, long) - Method in class org.postgresql.jdbc.AbstractBlobClob

This is simply passing the byte value of the pattern Blob

position(String, long) - Method in class org.postgresql.jdbc.PgClob

For now, this is not implemented.

position(Clob, long) - Method in class org.postgresql.jdbc.PgClob

This should be simply passing the byte value of the pattern Blob

POWER - Static variable in class org.postgresql.jdbc.EscapedFunctions

PreferQueryMode - Enum in org.postgresql.jdbc

Specifies which mode is used to execute queries to database: simple means ('Q' execute, no parse, no bind, text mode only), extended means always use bind/execute messages, extendedForPrepared means extended for prepared statements only.

prepare(Xid) - Method in class org.postgresql.xa.PGXAConnection

Preconditions: 1. xid !

prepareCall(String) - Method in class org.postgresql.jdbc.PgConnection

prepareCall(String, int, int, int) - Method in class org.postgresql.jdbc.PgConnection

prepareCall(String, int, int) - Method in class org.postgresql.jdbc.PgConnection

prepareStatement(String) - Method in class org.postgresql.jdbc.PgConnection

prepareStatement(String, int, int, int) - Method in class org.postgresql.jdbc.PgConnection

prepareStatement(String, int, int) - Method in class org.postgresql.jdbc.PgConnection

prepareStatement(String, int) - Method in class org.postgresql.jdbc.PgConnection

prepareStatement(String, int[]) - Method in class org.postgresql.jdbc.PgConnection

prepareStatement(String, String[]) - Method in class org.postgresql.jdbc.PgConnection

prepareThreshold - Variable in class org.postgresql.jdbc.PgConnection

previous() - Method in class org.postgresql.jdbc.PgResultSet

processNotifies() - Method in interface org.postgresql.core.QueryExecutor

Prior to attempting to retrieve notifications, we need to pull any recently received notifications off of the network buffers.

processNotifies() - Method in class org.postgresql.core.v3.QueryExecutorImpl

processResults(ResultHandler, int) - Method in class org.postgresql.core.v3.QueryExecutorImpl

PROTOCOL_VIOLATION - Static variable in class org.postgresql.util.PSQLState

The server sent us a response the driver was not prepared for and is either bizarre datastream corruption, a driver bug, or a protocol violation on the server's part.

Provider<T> - Interface in org.postgresql.core

Represents a provider of results.

providesQueryObjectGenerator() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

PSQLDriverVersion - Class in org.postgresql.util

This class holds the current build number and a utility program to print it and the file it came from.

PSQLDriverVersion() - Constructor for class org.postgresql.util.PSQLDriverVersion

PSQLException - Exception in org.postgresql.util

PSQLException(String, PSQLState, Throwable) - Constructor for exception org.postgresql.util.PSQLException

PSQLException(String, PSQLState) - Constructor for exception org.postgresql.util.PSQLException

PSQLException(ServerErrorMessage) - Constructor for exception org.postgresql.util.PSQLException

PSQLSavepoint - Class in org.postgresql.jdbc

PSQLSavepoint(int) - Constructor for class org.postgresql.jdbc.PSQLSavepoint

PSQLSavepoint(String) - Constructor for class org.postgresql.jdbc.PSQLSavepoint

PSQLState - Class in org.postgresql.util

This class is used for holding SQLState codes.

PSQLState(String) - Constructor for class org.postgresql.util.PSQLState

PSQLWarning - Exception in org.postgresql.util

PSQLWarning(ServerErrorMessage) - Constructor for exception org.postgresql.util.PSQLWarning

purgeTimerTasks() - Method in interface org.postgresql.core.BaseConnection

Invoke purge() on the underlying shared Timer so that internal resources will be released.

purgeTimerTasks() - Method in class org.postgresql.jdbc.PgConnection

put(Key, Value) - Method in class org.postgresql.util.LruCache

Returns given value to the cache

Q

QUARTER - Static variable in class org.postgresql.jdbc.EscapedFunctions

query - Variable in class org.postgresql.core.CachedQuery

Query - Interface in org.postgresql.core

Abstraction of a generic Query, hiding the details of any protocol-version-specific data needed to execute the query efficiently.

QUERY_BOTH_ROWS_AND_STATUS - Static variable in interface org.postgresql.core.QueryExecutor

Flag for query execution used by generated keys where we want to receive both the ResultSet and associated update count from the command status.

QUERY_DESCRIBE_ONLY - Static variable in interface org.postgresql.core.QueryExecutor

Flag for query execution when we don't really want to execute, we just want to get the parameter metadata for the statement.

QUERY_DISALLOW_BATCHING - Static variable in interface org.postgresql.core.QueryExecutor

Deprecated. in PgJDBC 9.4 as we now auto-size batches.

QUERY_EXECUTE_AS_SIMPLE - Static variable in interface org.postgresql.core.QueryExecutor

Execute the query via simple 'Q' command (not parse, bind, exec, but simple execute).

QUERY_FORCE_DESCRIBE_PORTAL - Static variable in interface org.postgresql.core.QueryExecutor

Force this query to be described at each execution.

QUERY_FORWARD_CURSOR - Static variable in interface org.postgresql.core.QueryExecutor

Flag for query execution that indicates a forward-fetch-capable cursor should be used if possible.

QUERY_NO_BINARY_TRANSFER - Static variable in interface org.postgresql.core.QueryExecutor

Flag for query execution to avoid using binary transfer.

QUERY_NO_METADATA - Static variable in interface org.postgresql.core.QueryExecutor

Flag for query execution that indicates that resultset metadata isn't needed and can be safely omitted.

QUERY_NO_RESULTS - Static variable in interface org.postgresql.core.QueryExecutor

Flag for query execution that indicates that a resultset isn't expected and the query executor can safely discard any rows (although the resultset should still appear to be from a resultset-returning query).

QUERY_ONESHOT - Static variable in interface org.postgresql.core.QueryExecutor

Flag for query execution that indicates the given Query object is unlikely to be reused.

QUERY_SUPPRESS_BEGIN - Static variable in interface org.postgresql.core.QueryExecutor

Flag for query execution that indicates the automatic BEGIN on the first statement when outside a transaction should not be done.

QueryExecutor - Interface in org.postgresql.core

Abstracts the protocol-specific details of executing a query.

QueryExecutorBase - Class in org.postgresql.core

QueryExecutorBase(Logger, PGStream, String, String, int, Properties) - Constructor for class org.postgresql.core.QueryExecutorBase

QueryExecutorImpl - Class in org.postgresql.core.v3

QueryExecutor implementation for the V3 protocol.

QueryExecutorImpl(PGStream, String, String, int, Properties, Logger) - Constructor for class org.postgresql.core.v3.QueryExecutorImpl

quotelessTableName(String) - Static method in class org.postgresql.jdbc.PgResultSet

Cracks out the table name and schema (if it exists) from a fully qualified table name.

R

RADIANS - Static variable in class org.postgresql.jdbc.EscapedFunctions

radius - Variable in class org.postgresql.geometric.PGcircle

This is the radius

read() - Method in class org.postgresql.copy.PGCopyInputStream

read(byte[]) - Method in class org.postgresql.copy.PGCopyInputStream

read(byte[], int, int) - Method in class org.postgresql.copy.PGCopyInputStream

read() - Method in class org.postgresql.core.VisibleBufferedInputStream

read(byte[], int, int) - Method in class org.postgresql.core.VisibleBufferedInputStream

read() - Method in class org.postgresql.largeobject.BlobInputStream

The minimum required to implement input stream

read(int) - Method in class org.postgresql.largeobject.LargeObject

Reads some data from the object, and return as a byte[] array

read(byte[], int, int) - Method in class org.postgresql.largeobject.LargeObject

Reads some data from the object into an existing array

READ - Static variable in class org.postgresql.largeobject.LargeObjectManager

This mode indicates we want to read an object

readBaseObject(ObjectInputStream) - Method in class org.postgresql.ds.common.BaseDataSource

readFromCopy() - Method in interface org.postgresql.copy.CopyOut

readFromCopy() - Method in class org.postgresql.copy.PGCopyInputStream

readFromCopy() - Method in class org.postgresql.core.v3.CopyOutImpl

readRaw() - Method in class org.postgresql.core.VisibleBufferedInputStream

Reads byte from the buffer without any checks.

readStartupMessages() - Method in class org.postgresql.core.v3.QueryExecutorImpl

READWRITE - Static variable in class org.postgresql.largeobject.LargeObjectManager

This mode is the default.

receive(int) - Method in class org.postgresql.core.PGStream

Reads in a given number of bytes from the backend

receive(byte[], int, int) - Method in class org.postgresql.core.PGStream

Reads in a given number of bytes from the backend

receiveChar() - Method in class org.postgresql.core.PGStream

Receives a single character from the backend

receiveEOF() - Method in class org.postgresql.core.PGStream

Consume an expected EOF from the backend

receiveErrorString(int) - Method in class org.postgresql.core.PGStream

Receives a fixed-size string from the backend, and tries to avoid "UTF-8 decode failed" errors.

receiveInteger2() - Method in class org.postgresql.core.PGStream

Receives a two byte integer from the backend

receiveInteger4() - Method in class org.postgresql.core.PGStream

Receives a four byte integer from the backend

receiveString(int) - Method in class org.postgresql.core.PGStream

Receives a fixed-size string from the backend.

receiveString() - Method in class org.postgresql.core.PGStream

Receives a null-terminated string from the backend.

receiveTupleV2(int, boolean) - Method in class org.postgresql.core.PGStream

Read a tuple from the back end.

receiveTupleV3() - Method in class org.postgresql.core.PGStream

Read a tuple from the back end.

recover(int) - Method in class org.postgresql.xa.PGXAConnection

Preconditions: 1. flag must be one of TMSTARTRSCAN, TMENDRSCAN, TMNOFLAGS or TMSTARTTRSCAN | TMENDRSCAN 2. if flag isn't TMSTARTRSCAN or TMSTARTRSCAN | TMENDRSCAN, a recovery scan must be in progress Postconditions: 1. list of prepared xids is returned

REF_CURSOR - Static variable in class org.postgresql.core.Oid

REF_CURSOR_ARRAY - Static variable in class org.postgresql.core.Oid

refreshRow() - Method in class org.postgresql.jdbc.PgResultSet

register() - Static method in class org.postgresql.Driver

Register the driver against DriverManager.

register(int, ArrayAssistant) - Static method in class org.postgresql.jdbc2.ArrayAssistantRegistry

registerOutParameter(int, int) - Method in interface org.postgresql.core.ParameterList

relative(int) - Method in class org.postgresql.jdbc.PgResultSet

releaseQuery(CachedQuery) - Method in interface org.postgresql.core.QueryExecutor

releaseQuery(CachedQuery) - Method in class org.postgresql.core.QueryExecutorBase

releaseSavepoint(Savepoint) - Method in class org.postgresql.jdbc.PgConnection

releaseTimer() - Method in class org.postgresql.util.SharedTimer

remove(String, String, String) - Static method in class org.postgresql.util.PGtokenizer

This removes the lead/trailing strings from a string

remove(String, String) - Method in class org.postgresql.util.PGtokenizer

This removes the lead/trailing strings from all tokens

removeAngle(String) - Static method in class org.postgresql.util.PGtokenizer

Removes < and > from the beginning and end of a string

removeAngle() - Method in class org.postgresql.util.PGtokenizer

Removes < and > from the beginning and end of all tokens

removeBox(String) - Static method in class org.postgresql.util.PGtokenizer

Removes [ and ] from the beginning and end of a string

removeBox() - Method in class org.postgresql.util.PGtokenizer

Removes [ and ] from the beginning and end of all tokens

removeConnectionEventListener(ConnectionEventListener) - Method in class org.postgresql.ds.PGPooledConnection

Removes a listener for close or fatal error events on the connection handed out to a client.

removeCurlyBrace(String) - Static method in class org.postgresql.util.PGtokenizer

Removes curly braces { and } from the beginning and end of a string

removeCurlyBrace() - Method in class org.postgresql.util.PGtokenizer

Removes < and > from the beginning and end of all tokens

removePara(String) - Static method in class org.postgresql.util.PGtokenizer

Removes ( and ) from the beginning and end of a string

removePara() - Method in class org.postgresql.util.PGtokenizer

Removes ( and ) from the beginning and end of all tokens

removeStatementEventListener(StatementEventListener) - Method in class org.postgresql.ds.PGPooledConnection

removeStoredDataSource() - Method in class org.postgresql.ds.PGPoolingDataSource

REPEAT - Static variable in class org.postgresql.jdbc.EscapedFunctions

REPLACE - Static variable in class org.postgresql.jdbc.EscapedFunctions

replaceProcessing(String, boolean, boolean) - Static method in class org.postgresql.core.Parser

Filter the SQL string of Java SQL Escape clauses.

replaceProcessingEnabled - Variable in class org.postgresql.jdbc.PgStatement

reportHostStatus(HostSpec, HostStatus) - Static method in class org.postgresql.hostchooser.GlobalHostStatusTracker

Store the actual observed host status.

requiresQuoting(int) - Method in interface org.postgresql.core.TypeInfo

requiresQuoting(int) - Method in class org.postgresql.jdbc.TypeInfoCache

requiresQuotingSqlType(int) - Method in interface org.postgresql.core.TypeInfo

Returns true if particular sqlType requires quoting.

requiresQuotingSqlType(int) - Method in class org.postgresql.jdbc.TypeInfoCache

Returns true if particular sqlType requires quoting.

reset() - Method in class org.postgresql.largeobject.BlobInputStream

Repositions this stream to the position at the time the mark method was last called on this input stream.

result - Variable in class org.postgresql.core.EncodingPredictor.DecodeResult

result - Variable in class org.postgresql.jdbc.PgStatement

The current results.

ResultCursor - Interface in org.postgresql.core

Abstraction of a cursor over a returned resultset.

ResultHandler - Interface in org.postgresql.core

Callback interface for passing query results from the protocol-specific layer to the protocol-independent JDBC implementation code.

ResultHandlerBase - Class in org.postgresql.core

Empty implementation of ResultHandler interface.

ResultHandlerBase() - Constructor for class org.postgresql.core.ResultHandlerBase

ResultHandlerDelegate - Class in org.postgresql.core

Internal to the driver class, please do not use in the application.

ResultHandlerDelegate(ResultHandler) - Constructor for class org.postgresql.core.ResultHandlerDelegate

resultsettype - Variable in class org.postgresql.jdbc.PgStatement

ResultWrapper - Class in org.postgresql.jdbc

Helper class that storing result info.

ResultWrapper(ResultSet) - Constructor for class org.postgresql.jdbc.ResultWrapper

ResultWrapper(int, long) - Constructor for class org.postgresql.jdbc.ResultWrapper

RIGHT - Static variable in class org.postgresql.jdbc.EscapedFunctions

rollback() - Method in class org.postgresql.jdbc.PgConnection

rollback(Savepoint) - Method in class org.postgresql.jdbc.PgConnection

rollback(Xid) - Method in class org.postgresql.xa.PGXAConnection

Preconditions: 1. xid is known to the RM or it's in prepared state Implementation deficiency preconditions: 1. xid must be associated with this connection if it's not in prepared state.

ROUND - Static variable in class org.postgresql.jdbc.EscapedFunctions

row_offset - Variable in class org.postgresql.jdbc.PgResultSet

rowChangesAreDetected(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

rowChangesAreVisible(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

rowDeleted() - Method in class org.postgresql.jdbc.PgResultSet

rowInserted() - Method in class org.postgresql.jdbc.PgResultSet

rows - Variable in class org.postgresql.jdbc.PgResultSet

rowUpdated() - Method in class org.postgresql.jdbc.PgResultSet

RTRIM - Static variable in class org.postgresql.jdbc.EscapedFunctions

run(QueryExecutor, String, boolean) - Static method in class org.postgresql.core.SetupQueryRunner

run() - Method in class org.postgresql.jdbc.PgConnection.AbortCommand

S

scale(int) - Method in class org.postgresql.util.PGInterval

Scale this interval by an integer factor.

scanCStringLength() - Method in class org.postgresql.core.VisibleBufferedInputStream

Scans the length of the next null terminated string (C-style string) from the stream.

SECOND - Static variable in class org.postgresql.jdbc.EscapedFunctions

secureProgress() - Method in interface org.postgresql.core.ResultHandler

Callback for batch statements.

secureProgress() - Method in class org.postgresql.core.ResultHandlerBase

secureProgress() - Method in class org.postgresql.core.ResultHandlerDelegate

secureProgress() - Method in class org.postgresql.jdbc.BatchResultHandler

seek(int, int) - Method in class org.postgresql.largeobject.LargeObject

Sets the current position within the object.

seek(int) - Method in class org.postgresql.largeobject.LargeObject

Sets the current position within the object.

seek64(long, int) - Method in class org.postgresql.largeobject.LargeObject

Sets the current position within the object using 64-bit value (9.3+)

SEEK_CUR - Static variable in class org.postgresql.largeobject.LargeObject

Indicates a seek from the current position

SEEK_END - Static variable in class org.postgresql.largeobject.LargeObject

Indicates a seek from the end of a file

SEEK_SET - Static variable in class org.postgresql.largeobject.LargeObject

Indicates a seek from the begining of a file

send(byte[]) - Method in class org.postgresql.core.PGStream

Send an array of bytes to the backend

send(byte[], int) - Method in class org.postgresql.core.PGStream

Send a fixed-size array of bytes to the backend.

send(byte[], int, int) - Method in class org.postgresql.core.PGStream

Send a fixed-size array of bytes to the backend.

sendChar(int) - Method in class org.postgresql.core.PGStream

Sends a single character to the back end

sendCloseMessage() - Method in class org.postgresql.core.QueryExecutorBase

sendCloseMessage() - Method in class org.postgresql.core.v3.QueryExecutorImpl

sendInteger2(int) - Method in class org.postgresql.core.PGStream

Sends a 2-byte integer (short) to the back end

sendInteger4(int) - Method in class org.postgresql.core.PGStream

Sends a 4-byte integer to the back end

sendQueryCancel() - Method in interface org.postgresql.core.QueryExecutor

Sends a query cancellation for this connection.

sendQueryCancel() - Method in class org.postgresql.core.QueryExecutorBase

sendStream(InputStream, int) - Method in class org.postgresql.core.PGStream

Copy data from an input stream to the connection.

ServerErrorMessage - Class in org.postgresql.util

ServerErrorMessage(EncodingPredictor.DecodeResult, int) - Constructor for class org.postgresql.util.ServerErrorMessage

ServerErrorMessage(String, int) - Constructor for class org.postgresql.util.ServerErrorMessage

ServerVersion - Enum in org.postgresql.core

Enumeration for PostgreSQL versions.

set(Properties, String) - Method in enum org.postgresql.PGProperty

Set the value for this connection parameter in the given Properties

set(Properties, boolean) - Method in enum org.postgresql.PGProperty

Set the boolean value for this connection parameter in the given Properties

set(Properties, int) - Method in enum org.postgresql.PGProperty

Set the int value for this connection parameter in the given Properties

setAllowEncodingChanges(boolean) - Method in class org.postgresql.ds.common.BaseDataSource

setApplicationName(String) - Method in class org.postgresql.core.v3.QueryExecutorImpl

setApplicationName(String) - Method in class org.postgresql.ds.common.BaseDataSource

setAsciiStream(long) - Method in class org.postgresql.jdbc.PgClob

setAssumeMinServerVersion(String) - Method in class org.postgresql.ds.common.BaseDataSource

setAutoCommit(boolean) - Method in class org.postgresql.jdbc.PgConnection

setAutoSave(AutoSave) - Method in interface org.postgresql.core.QueryExecutor

setAutoSave(AutoSave) - Method in class org.postgresql.core.QueryExecutorBase

setAutosave(AutoSave) - Method in class org.postgresql.ds.common.BaseDataSource

setAutosave(AutoSave) - Method in class org.postgresql.jdbc.PgConnection

setAutosave(AutoSave) - Method in interface org.postgresql.PGConnection

Configures if connection should use automatic savepoints.

setBackendKeyData(int, int) - Method in class org.postgresql.core.QueryExecutorBase

setBinaryParameter(int, byte[], int) - Method in interface org.postgresql.core.ParameterList

Binds given byte[] value to a parameter.

setBinaryReceiveOids(Set<Integer>) - Method in interface org.postgresql.core.QueryExecutor

Sets the oids that should be received using binary encoding.

setBinaryReceiveOids(Set<Integer>) - Method in class org.postgresql.core.v3.QueryExecutorImpl

setBinarySendOids(Set<Integer>) - Method in interface org.postgresql.core.QueryExecutor

Sets the oids that should be sent using binary encoding.

setBinarySendOids(Set<Integer>) - Method in class org.postgresql.core.v3.QueryExecutorImpl

setBinaryStream(long) - Method in class org.postgresql.jdbc.AbstractBlobClob

setBinaryStream() - Method in class org.postgresql.jdbc.PgSQLXML

setBinaryTransfer(boolean) - Method in class org.postgresql.ds.common.BaseDataSource

setBinaryTransferDisable(String) - Method in class org.postgresql.ds.common.BaseDataSource

setBinaryTransferEnable(String) - Method in class org.postgresql.ds.common.BaseDataSource

setBytea(int, byte[], int, int) - Method in interface org.postgresql.core.ParameterList

Binds a binary bytea value stored as a bytearray to a parameter.

setBytea(int, InputStream, int) - Method in interface org.postgresql.core.ParameterList

Binds a binary bytea value stored as an InputStream.

setBytea(int, InputStream) - Method in interface org.postgresql.core.ParameterList

Binds a binary bytea value stored as an InputStream.

setBytes(long, byte[]) - Method in class org.postgresql.jdbc.PgBlob

setBytes(long, byte[], int, int) - Method in class org.postgresql.jdbc.PgBlob

setByteValue(byte[], int) - Method in class org.postgresql.geometric.PGbox

setByteValue(byte[], int) - Method in class org.postgresql.geometric.PGpoint

setByteValue(byte[], int) - Method in interface org.postgresql.util.PGBinaryObject

This method is called to set the value of this object.

setCalendar(Calendar) - Method in class org.postgresql.util.PGTime

Sets the calendar object for this time.

setCalendar(Calendar) - Method in class org.postgresql.util.PGTimestamp

Sets the calendar object for this timestamp.

setCancelSignalTimeout(int) - Method in class org.postgresql.ds.common.BaseDataSource

setCatalog(String) - Method in class org.postgresql.jdbc.PgConnection

setCharacterStream(long) - Method in class org.postgresql.jdbc.PgClob

setCharacterStream() - Method in class org.postgresql.jdbc.PgSQLXML

setCharset(String) - Method in class org.postgresql.ds.common.BaseDataSource

setClientInfo(String, String) - Method in class org.postgresql.jdbc.PgConnection

setClientInfo(Properties) - Method in class org.postgresql.jdbc.PgConnection

setCompatible(String) - Method in class org.postgresql.ds.common.BaseDataSource

setConnectTimeout(int) - Method in class org.postgresql.ds.common.BaseDataSource

setCurrentSchema(String) - Method in class org.postgresql.ds.common.BaseDataSource

setCursorName(String) - Method in class org.postgresql.jdbc.PgConnection

In SQL, a result table can be retrieved through a cursor that is named.

setCursorName(String) - Method in class org.postgresql.jdbc.PgStatement

setDatabaseMetadataCacheFields(int) - Method in class org.postgresql.ds.common.BaseDataSource

setDatabaseMetadataCacheFieldsMiB(int) - Method in class org.postgresql.ds.common.BaseDataSource

setDatabaseName(String) - Method in class org.postgresql.ds.common.BaseDataSource

Sets the name of the PostgreSQL database, running on the server identified by the serverName property.

setDatabaseName(String) - Method in class org.postgresql.ds.PGPoolingDataSource

Ensures the DataSource properties are not changed after the DataSource has been used.

setDataSourceName(String) - Method in class org.postgresql.ds.PGPoolingDataSource

Sets the name of this DataSource.

setDays(int) - Method in class org.postgresql.util.PGInterval

Set the days of this interval to the specified value

setDefaultAutoCommit(boolean) - Method in class org.postgresql.ds.PGConnectionPoolDataSource

Sets whether connections supplied by this pool will have autoCommit turned on by default.

setDefaultFetchSize(int) - Method in class org.postgresql.jdbc.PgConnection

setDefaultFetchSize(int) - Method in interface org.postgresql.PGConnection

Set the default fetch size for statements created from this connection

setDefaultRowFetchSize(int) - Method in class org.postgresql.ds.common.BaseDataSource

setDisableColumnSanitiser(boolean) - Method in class org.postgresql.ds.common.BaseDataSource

setDisableColumnSanitiser(boolean) - Method in class org.postgresql.jdbc.PgConnection

setEncoding(Encoding) - Method in class org.postgresql.core.PGStream

Change the encoding used by this connection.

setEncoding(Encoding) - Method in class org.postgresql.core.QueryExecutorBase

setEscapeProcessing(boolean) - Method in class org.postgresql.jdbc.PgStatement

setFetchDirection(int) - Method in class org.postgresql.jdbc.PgResultSet

setFetchDirection(int) - Method in class org.postgresql.jdbc.PgStatement

setFetchSize(int) - Method in class org.postgresql.jdbc.PgResultSet

setFetchSize(int) - Method in class org.postgresql.jdbc.PgStatement

setFlushCacheOnDeallocate(boolean) - Method in interface org.postgresql.core.BaseConnection

By default, the connection resets statement cache in case deallocate all/discard all message is observed.

setFlushCacheOnDeallocate(boolean) - Method in interface org.postgresql.core.QueryExecutor

By default, the connection resets statement cache in case deallocate all/discard all message is observed.

setFlushCacheOnDeallocate(boolean) - Method in class org.postgresql.core.QueryExecutorBase

setFlushCacheOnDeallocate(boolean) - Method in class org.postgresql.jdbc.PgConnection

setForceBinary(boolean) - Method in class org.postgresql.jdbc.PgConnection

setFormat(int) - Method in class org.postgresql.core.Field

setFromReference(Reference) - Method in class org.postgresql.ds.common.BaseDataSource

setGssLib(String) - Method in class org.postgresql.ds.common.BaseDataSource

setHoldability(int) - Method in class org.postgresql.jdbc.PgConnection

setHostRecheckSeconds(int) - Method in class org.postgresql.ds.common.BaseDataSource

setHours(int) - Method in class org.postgresql.util.PGInterval

Set the hours of this interval to the specified value

setInitialConnections(int) - Method in class org.postgresql.ds.PGPoolingDataSource

Sets the number of connections that will be created when this DataSource is initialized.

setIntParameter(int, int) - Method in interface org.postgresql.core.ParameterList

Binds an integer value to a parameter.

setJaasApplicationName(String) - Method in class org.postgresql.ds.common.BaseDataSource

setKerberosServerName(String) - Method in class org.postgresql.ds.common.BaseDataSource

setLargeMaxRows(long) - Method in class org.postgresql.jdbc.PgStatement

setLiteralParameter(int, String, int) - Method in interface org.postgresql.core.ParameterList

Binds a String value that is an unquoted literal to the server's query parser (for example, a bare integer) to a parameter.

setLoadBalanceHosts(boolean) - Method in class org.postgresql.ds.common.BaseDataSource

setLocation(int, int) - Method in class org.postgresql.geometric.PGpoint

Moves the point to the supplied coordinates. refer to java.awt.Point for description of this

setLocation(Point) - Method in class org.postgresql.geometric.PGpoint

Moves the point to the supplied java.awt.Point refer to java.awt.Point for description of this

setLoginTimeout(int) - Method in class org.postgresql.ds.common.BaseDataSource

setLogLevel(int) - Method in class org.postgresql.core.Logger

setLogLevel(int) - Static method in class org.postgresql.Driver

used to turn logging on to a certain level, can be called by specifying fully qualified class ie org.postgresql.Driver.setLogLevel()

setLogLevel(int) - Method in class org.postgresql.ds.common.BaseDataSource

setLoglevel(int) - Method in class org.postgresql.ds.common.BaseDataSource

setLogUnclosedConnections(boolean) - Method in class org.postgresql.ds.common.BaseDataSource

setLogWriter(PrintWriter) - Method in class org.postgresql.ds.common.BaseDataSource

The DataSource will note every connection opened to the provided log writer.

setMaxConnections(int) - Method in class org.postgresql.ds.PGPoolingDataSource

Sets the maximum number of connections that the pool will allow.

setMaxFieldSize(int) - Method in class org.postgresql.jdbc.PgStatement

setMaxRows(int) - Method in class org.postgresql.jdbc.PgStatement

setMetadata(FieldMetadata) - Method in class org.postgresql.core.Field

setMinutes(int) - Method in class org.postgresql.util.PGInterval

Set the minutes of this interval to the specified value

setMonths(int) - Method in class org.postgresql.util.PGInterval

Set the months of this interval to the specified value

setNetworkTimeout(Executor, int) - Method in class org.postgresql.jdbc.PgConnection

setNull(int, int) - Method in interface org.postgresql.core.ParameterList

Binds a SQL NULL value to a parameter.

setPassword(String) - Method in class org.postgresql.ds.common.BaseDataSource

Sets the password to connect with by default.

setPassword(String) - Method in class org.postgresql.ds.PGPoolingDataSource

Ensures the DataSource properties are not changed after the DataSource has been used.

setPGType(String) - Method in class org.postgresql.core.Field

setPoolable(boolean) - Method in class org.postgresql.jdbc.PgStatement

setPortNumber(int) - Method in class org.postgresql.ds.common.BaseDataSource

Gets the port which the PostgreSQL server is listening on for TCP/IP connections.

setPortNumber(int) - Method in class org.postgresql.ds.PGPoolingDataSource

Ensures the DataSource properties are not changed after the DataSource has been used.

setPreferQueryMode(PreferQueryMode) - Method in class org.postgresql.ds.common.BaseDataSource

setPreparedStatementCacheQueries(int) - Method in class org.postgresql.ds.common.BaseDataSource

setPreparedStatementCacheSizeMiB(int) - Method in class org.postgresql.ds.common.BaseDataSource

setPrepareThreshold(int) - Method in class org.postgresql.ds.common.BaseDataSource

setPrepareThreshold(int) - Method in class org.postgresql.jdbc.PgConnection

setPrepareThreshold(int) - Method in class org.postgresql.jdbc.PgStatement

setPrepareThreshold(int) - Method in interface org.postgresql.PGConnection

Set the default statement reuse threshold before enabling server-side prepare.

setPrepareThreshold(int) - Method in interface org.postgresql.PGStatement

Sets the reuse threshold for using server-prepared statements.

setProperty(String, String) - Method in class org.postgresql.ds.common.BaseDataSource

setProperty(PGProperty, String) - Method in class org.postgresql.ds.common.BaseDataSource

setProtocolVersion(int) - Method in class org.postgresql.ds.common.BaseDataSource

setQueryTimeout(int) - Method in class org.postgresql.jdbc.PgStatement

setQueryTimeoutMs(int) - Method in class org.postgresql.jdbc.PgStatement

Sets the queryTimeout limit

setReadOnly(boolean) - Method in class org.postgresql.ds.common.BaseDataSource

setReadOnly(boolean) - Method in class org.postgresql.jdbc.PgConnection

setReceiveBufferSize(int) - Method in class org.postgresql.ds.common.BaseDataSource

setResult(Class<T>) - Method in class org.postgresql.jdbc.PgSQLXML

setReWriteBatchedInserts(boolean) - Method in class org.postgresql.ds.common.BaseDataSource

setSavepoint() - Method in class org.postgresql.jdbc.PgConnection

setSavepoint(String) - Method in class org.postgresql.jdbc.PgConnection

setSchema(String) - Method in class org.postgresql.jdbc.PgConnection

setSeconds(double) - Method in class org.postgresql.util.PGInterval

Set the seconds of this interval to the specified value

setSendBufferSize(int) - Method in class org.postgresql.ds.common.BaseDataSource

setServerName(String) - Method in class org.postgresql.ds.common.BaseDataSource

Sets the name of the host the PostgreSQL database is running on.

setServerName(String) - Method in class org.postgresql.ds.PGPoolingDataSource

Ensures the DataSource properties are not changed after the DataSource has been used.

setServerVersion(String) - Method in class org.postgresql.core.QueryExecutorBase

setServerVersionNum(int) - Method in class org.postgresql.core.QueryExecutorBase

setSocketFactory(String) - Method in class org.postgresql.ds.common.BaseDataSource

setSocketFactoryArg(String) - Method in class org.postgresql.ds.common.BaseDataSource

setSocketTimeout(int) - Method in class org.postgresql.ds.common.BaseDataSource

setSQLType(int) - Method in class org.postgresql.core.Field

setSsl(boolean) - Method in class org.postgresql.ds.common.BaseDataSource

setSslCert(String) - Method in class org.postgresql.ds.common.BaseDataSource

setSslfactory(String) - Method in class org.postgresql.ds.common.BaseDataSource

setSslFactoryArg(String) - Method in class org.postgresql.ds.common.BaseDataSource

setSslHostnameVerifier(String) - Method in class org.postgresql.ds.common.BaseDataSource

setSslKey(String) - Method in class org.postgresql.ds.common.BaseDataSource

setSslMode(String) - Method in class org.postgresql.ds.common.BaseDataSource

setSslPassword(String) - Method in class org.postgresql.ds.common.BaseDataSource

setSslPasswordCallback(String) - Method in class org.postgresql.ds.common.BaseDataSource

setSslRootCert(String) - Method in class org.postgresql.ds.common.BaseDataSource

setSspiServiceClass(String) - Method in class org.postgresql.ds.common.BaseDataSource

setStandardConformingStrings(boolean) - Method in class org.postgresql.core.QueryExecutorBase

setString(long, String) - Method in class org.postgresql.jdbc.PgClob

setString(long, String, int, int) - Method in class org.postgresql.jdbc.PgClob

setString(String) - Method in class org.postgresql.jdbc.PgSQLXML

setStringParameter(int, String, int) - Method in interface org.postgresql.core.ParameterList

Binds a String value that needs to be quoted for the server's parser to understand (for example, a timestamp) to a parameter.

setStringType(String) - Method in class org.postgresql.ds.common.BaseDataSource

setTargetServerType(String) - Method in class org.postgresql.ds.common.BaseDataSource

setTcpKeepAlive(boolean) - Method in class org.postgresql.ds.common.BaseDataSource

setTimeZone(TimeZone) - Method in class org.postgresql.core.v3.QueryExecutorImpl

setTransactionIsolation(int) - Method in class org.postgresql.jdbc.PgConnection

setTransactionState(TransactionState) - Method in class org.postgresql.core.QueryExecutorBase

setTransactionTimeout(int) - Method in class org.postgresql.xa.PGXAConnection

We don't do transaction timeouts.

setType(String) - Method in class org.postgresql.util.PGobject

This method sets the type of this object.

setTypeMap(Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgConnection

setTypeMapImpl(Map<String, Class<?>>) - Method in class org.postgresql.jdbc.PgConnection

setUnknownLength(int) - Method in class org.postgresql.ds.common.BaseDataSource

SetupQueryRunner - Class in org.postgresql.core

Poor man's Statement & ResultSet, used for initial queries while we're still initializing the system.

SetupQueryRunner() - Constructor for class org.postgresql.core.SetupQueryRunner

setUrl(String) - Method in class org.postgresql.ds.common.BaseDataSource

Sets properties from a DriverManager URL.

setUser(String) - Method in class org.postgresql.ds.common.BaseDataSource

Sets the user to connect as by default.

setUser(String) - Method in class org.postgresql.ds.PGPoolingDataSource

Ensures the DataSource properties are not changed after the DataSource has been used.

setUseServerPrepare(boolean) - Method in class org.postgresql.jdbc.PgStatement

setUseServerPrepare(boolean) - Method in interface org.postgresql.PGStatement

Deprecated. As of build 302, replaced by PGStatement.setPrepareThreshold(int)

setUseSpNego(boolean) - Method in class org.postgresql.ds.common.BaseDataSource

setValue(String) - Method in class org.postgresql.geometric.PGbox

This method sets the value of this object.

setValue(String) - Method in class org.postgresql.geometric.PGcircle

setValue(String) - Method in class org.postgresql.geometric.PGline

setValue(String) - Method in class org.postgresql.geometric.PGlseg

setValue(String) - Method in class org.postgresql.geometric.PGpath

setValue(String) - Method in class org.postgresql.geometric.PGpoint

setValue(String) - Method in class org.postgresql.geometric.PGpolygon

setValue(String) - Method in class org.postgresql.util.PGInterval

Sets a interval string represented value to this instance.

setValue(int, int, int, int, int, double) - Method in class org.postgresql.util.PGInterval

Set all values of this interval to the specified values

setValue(String) - Method in class org.postgresql.util.PGmoney

setValue(String) - Method in class org.postgresql.util.PGobject

This method sets the value of this object.

setYears(int) - Method in class org.postgresql.util.PGInterval

Set the years of this interval to the specified value

SharedTimer - Class in org.postgresql.util

SharedTimer(Logger) - Constructor for class org.postgresql.util.SharedTimer

SIGN - Static variable in class org.postgresql.jdbc.EscapedFunctions

SimpleDataSource - Class in org.postgresql.jdbc2.optional

SimpleDataSource() - Constructor for class org.postgresql.jdbc2.optional.SimpleDataSource

SIN - Static variable in class org.postgresql.jdbc.EscapedFunctions

SingleCertValidatingFactory - Class in org.postgresql.ssl

Provides a SSLSocketFactory that authenticates the remote server against an explicit pre-shared SSL certificate.

SingleCertValidatingFactory(String) - Constructor for class org.postgresql.ssl.SingleCertValidatingFactory

SingleCertValidatingFactory.SingleCertTrustManager - Class in org.postgresql.ssl

SingleCertValidatingFactory.SingleCertTrustManager(InputStream) - Constructor for class org.postgresql.ssl.SingleCertValidatingFactory.SingleCertTrustManager

SingleHostChooser - Class in org.postgresql.hostchooser

Host chooser that returns the single host.

SingleHostChooser(HostSpec) - Constructor for class org.postgresql.hostchooser.SingleHostChooser

size() - Method in class org.postgresql.largeobject.LargeObject

This method is inefficient, as the only way to find out the size of the object is to seek to the end, record the current position, then return to the original position.

size64() - Method in class org.postgresql.largeobject.LargeObject

See #size() for information about efficiency.

skip(int) - Method in class org.postgresql.core.PGStream

skip(long) - Method in class org.postgresql.core.VisibleBufferedInputStream

SocketFactoryFactory - Class in org.postgresql.core

Instantiates SocketFactory based on the PGProperty.SOCKET_FACTORY.

SocketFactoryFactory() - Constructor for class org.postgresql.core.SocketFactoryFactory

SPACE - Static variable in class org.postgresql.jdbc.EscapedFunctions

SQL_TSI_DAY - Static variable in class org.postgresql.jdbc.EscapedFunctions

SQL_TSI_FRAC_SECOND - Static variable in class org.postgresql.jdbc.EscapedFunctions

SQL_TSI_HOUR - Static variable in class org.postgresql.jdbc.EscapedFunctions

SQL_TSI_MINUTE - Static variable in class org.postgresql.jdbc.EscapedFunctions

SQL_TSI_MONTH - Static variable in class org.postgresql.jdbc.EscapedFunctions

SQL_TSI_QUARTER - Static variable in class org.postgresql.jdbc.EscapedFunctions

SQL_TSI_ROOT - Static variable in class org.postgresql.jdbc.EscapedFunctions

SQL_TSI_SECOND - Static variable in class org.postgresql.jdbc.EscapedFunctions

SQL_TSI_WEEK - Static variable in class org.postgresql.jdbc.EscapedFunctions

SQL_TSI_YEAR - Static variable in class org.postgresql.jdbc.EscapedFunctions

sqlceiling(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

ceiling to ceil translation

sqlchar(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

char to chr translation

SqlCommand - Class in org.postgresql.core

Data Modification Language inspection support.

SqlCommandType - Enum in org.postgresql.core

Type information inspection support.

sqlconcat(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

concat translation

sqlcurdate(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

curdate to current_date translation

sqlcurtime(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

curtime to current_time translation

sqldatabase(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

database translation

sqldayname(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

dayname translation

sqldayofmonth(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

dayofmonth translation

sqldayofweek(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

dayofweek translation adding 1 to postgresql function since we expect values from 1 to 7

sqldayofyear(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

dayofyear translation

sqlhour(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

hour translation

sqlifnull(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

ifnull translation

sqlinsert(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

insert to overlay translation

sqllcase(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

lcase to lower translation

sqlleft(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

left to substring translation

sqllength(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

length translation

sqllocate(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

locate translation

sqllog(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

log to ln translation

sqllog10(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

log10 to log translation

sqlltrim(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

ltrim translation

sqlminute(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

minute translation

sqlmonth(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

month translation

sqlmonthname(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

monthname translation

sqlpower(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

power to pow translation

sqlquarter(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

quarter translation

sqlright(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

right to substring translation

sqlrtrim(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

rtrim translation

sqlsecond(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

second translation

sqlspace(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

space translation

sqlsubstring(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

substring to substr translation

sqltimestampadd(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

time stamp add

sqltimestampdiff(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

time stamp diff

sqltruncate(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

truncate to trunc translation

sqlucase(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

ucase to upper translation

sqluser(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

user translation

sqlweek(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

week translation

sqlyear(List<?>) - Static method in class org.postgresql.jdbc.EscapedFunctions

year translation

SQRT - Static variable in class org.postgresql.jdbc.EscapedFunctions

SSPI_DEFAULT_SPN_SERVICE_CLASS - Static variable in class org.postgresql.sspi.SSPIClient

SSPIClient - Class in org.postgresql.sspi

Use Waffle-JNI to support SSPI authentication when PgJDBC is running on a Windows client and talking to a Windows server.

SSPIClient(PGStream, String, boolean, Logger) - Constructor for class org.postgresql.sspi.SSPIClient

Instantiate an SSPIClient for authentication of a connection.

start(BundleContext) - Method in class org.postgresql.osgi.PGBundleActivator

start(Xid, int) - Method in class org.postgresql.xa.PGXAConnection

Preconditions: 1. flags must be one of TMNOFLAGS, TMRESUME or TMJOIN 2. xid !

startCopy(String, boolean) - Method in interface org.postgresql.core.QueryExecutor

Issues a COPY FROM STDIN / COPY TO STDOUT statement and returns handler for associated operation.

startCopy(String, boolean) - Method in class org.postgresql.core.v3.QueryExecutorImpl

Sends given query to BE to start, initialize and lock connection for a CopyOperation.

startSSPI() - Method in interface org.postgresql.sspi.ISSPIClient

startSSPI() - Method in class org.postgresql.sspi.SSPIClient

Respond to an authentication request from the back-end for SSPI authentication (AUTH_REQ_SSPI).

statement - Variable in class org.postgresql.jdbc.PgResultSet

STATEMENT_NOT_ALLOWED_IN_FUNCTION_CALL - Static variable in class org.postgresql.util.PSQLState

stop(BundleContext) - Method in class org.postgresql.osgi.PGBundleActivator

storesLowerCaseIdentifiers() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

storesLowerCaseQuotedIdentifiers() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

storesMixedCaseIdentifiers() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

storesMixedCaseQuotedIdentifiers() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

storesUpperCaseIdentifiers() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

storesUpperCaseQuotedIdentifiers() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

StreamWrapper - Class in org.postgresql.util

Wrapper around a length-limited InputStream.

StreamWrapper(byte[], int, int) - Constructor for class org.postgresql.util.StreamWrapper

StreamWrapper(InputStream, int) - Constructor for class org.postgresql.util.StreamWrapper

StreamWrapper(InputStream) - Constructor for class org.postgresql.util.StreamWrapper

SUBSTRING - Static variable in class org.postgresql.jdbc.EscapedFunctions

supportsAlterTableWithAddColumn() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsAlterTableWithDropColumn() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsANSI92EntryLevelSQL() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Does this driver support the ANSI-92 entry level SQL grammar?

supportsANSI92FullSQL() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsANSI92IntermediateSQL() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsBatchUpdates() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsCatalogsInDataManipulation() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsCatalogsInIndexDefinitions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsCatalogsInPrivilegeDefinitions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsCatalogsInProcedureCalls() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsCatalogsInTableDefinitions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsColumnAliasing() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsConvert() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsConvert(int, int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsCoreSQLGrammar() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Does this driver support the Core ODBC SQL grammar.

supportsCorrelatedSubqueries() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsDataDefinitionAndDataManipulationTransactions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsDataManipulationTransactionsOnly() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsDifferentTableCorrelationNames() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsExpressionsInOrderBy() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsExtendedSQLGrammar() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Does this driver support the Extended (Level 2) ODBC SQL grammar.

supportsFullOuterJoins() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsGetGeneratedKeys() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsGroupBy() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsGroupByBeyondSelect() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsGroupByUnrelated() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsIntegrityEnhancementFacility() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsLikeEscapeClause() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsLimitedOuterJoins() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsMinimumSQLGrammar() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

This grammar is defined at: http://www.

supportsMixedCaseIdentifiers() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case?

supportsMixedCaseQuotedIdentifiers() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case?

supportsMultipleOpenResults() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsMultipleResultSets() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsMultipleTransactions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsNamedParameters() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsNonNullableColumns() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsOpenCursorsAcrossCommit() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

In PostgreSQL, Cursors are only open within transactions.

supportsOpenCursorsAcrossRollback() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsOpenStatementsAcrossCommit() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Can statements remain open across commits?

supportsOpenStatementsAcrossRollback() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Can statements remain open across rollbacks?

supportsOrderByUnrelated() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsOuterJoins() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsPositionedDelete() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

We support cursors for gets only it seems.

supportsPositionedUpdate() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsRefCursors() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsResultSetConcurrency(int, int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsResultSetHoldability(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsResultSetType(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsSavepoints() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsSchemasInDataManipulation() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsSchemasInIndexDefinitions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsSchemasInPrivilegeDefinitions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsSchemasInProcedureCalls() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsSchemasInTableDefinitions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsSelectForUpdate() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsStatementPooling() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsStoredFunctionsUsingCallSyntax() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsStoredProcedures() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsSubqueriesInComparisons() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsSubqueriesInExists() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsSubqueriesInIns() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsSubqueriesInQuantifieds() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsTableCorrelationNames() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsTransactionIsolationLevel(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

We only support TRANSACTION_SERIALIZABLE and TRANSACTION_READ_COMMITTED before 8.0; from 8.0 READ_UNCOMMITTED and REPEATABLE_READ are accepted aliases for READ_COMMITTED.

supportsTransactions() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsUnion() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

supportsUnionAll() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

SYNTAX_ERROR - Static variable in class org.postgresql.util.PSQLState

SYSTEM_ERROR - Static variable in class org.postgresql.util.PSQLState

T

TAN - Static variable in class org.postgresql.jdbc.EscapedFunctions

tell() - Method in class org.postgresql.largeobject.LargeObject

tell64() - Method in class org.postgresql.largeobject.LargeObject

TEXT - Static variable in class org.postgresql.core.Oid

TEXT_ARRAY - Static variable in class org.postgresql.core.Oid

TEXT_FORMAT - Static variable in class org.postgresql.core.Field

this_row - Variable in class org.postgresql.jdbc.PgResultSet

throwKeyManagerException() - Method in class org.postgresql.ssl.jdbc4.LazyKeyManager

getCertificateChain and getPrivateKey cannot throw exeptions, therefore any exception is stored in LazyKeyManager.error and can be raised by this method

throwKeyManagerException() - Method in class org.postgresql.ssl.jdbc4.LibPQFactory

Propagates any exception from LazyKeyManager

TIME - Static variable in class org.postgresql.core.Oid

TIME_ARRAY - Static variable in class org.postgresql.core.Oid

timeout - Variable in class org.postgresql.jdbc.PgStatement

Timeout (in milliseconds) for a query

TIMESTAMP - Static variable in class org.postgresql.core.Oid

TIMESTAMP_ARRAY - Static variable in class org.postgresql.core.Oid

TIMESTAMPADD - Static variable in class org.postgresql.jdbc.EscapedFunctions

TIMESTAMPDIFF - Static variable in class org.postgresql.jdbc.EscapedFunctions

TIMESTAMPTZ - Static variable in class org.postgresql.core.Oid

TIMESTAMPTZ_ARRAY - Static variable in class org.postgresql.core.Oid

TimestampUtils - Class in org.postgresql.jdbc

Misc utils for handling time and date values.

timeToString(Date, boolean) - Method in class org.postgresql.jdbc.TimestampUtils

Returns the given time value as String matching what the current postgresql server would send in text mode.

TIMETZ - Static variable in class org.postgresql.core.Oid

TIMETZ_ARRAY - Static variable in class org.postgresql.core.Oid

toBigDecimal(String) - Static method in class org.postgresql.jdbc.PgResultSet

toBigDecimal(String, int) - Method in class org.postgresql.jdbc.PgResultSet

toBinDate(TimeZone, byte[], Date) - Method in class org.postgresql.jdbc.TimestampUtils

Converts the SQL Date to binary representation for Oid.DATE.

toBoolean(String) - Static method in class org.postgresql.jdbc.PgResultSet

toBytes(byte[], int) - Method in class org.postgresql.geometric.PGbox

toBytes(byte[], int) - Method in class org.postgresql.geometric.PGpoint

Populate the byte array with PGpoint in the binary syntax expected by org.postgresql

toBytes() - Method in class org.postgresql.jdbc.PgArray

toBytes(Map<?, ?>, Encoding) - Static method in class org.postgresql.util.HStoreConverter

toBytes(byte[], int) - Method in interface org.postgresql.util.PGBinaryObject

This method is called the to store the value of the object, in the binary form required by org.postgresql.

toBytes(byte[]) - Static method in class org.postgresql.util.PGbytea

toDate(Calendar, String) - Method in class org.postgresql.jdbc.TimestampUtils

toDateBin(TimeZone, byte[]) - Method in class org.postgresql.jdbc.TimestampUtils

Returns the SQL Date object matching the given bytes with Oid.DATE.

toDouble(String) - Static method in class org.postgresql.jdbc.PgResultSet

toDriverPropertyInfo(Properties) - Method in enum org.postgresql.PGProperty

Convert this connection parameter and the value read from the given Properties into a DriverPropertyInfo

toFloat(String) - Static method in class org.postgresql.jdbc.PgResultSet

toHexString(byte[]) - Static method in class org.postgresql.core.Utils

Turn a bytearray into a printable form, representing each byte in hex.

toInt(String) - Static method in class org.postgresql.jdbc.PgResultSet

tokenize(String, char) - Method in class org.postgresql.util.PGtokenizer

This resets this tokenizer with a new string and/or delimiter.

tokenizeToken(int, char) - Method in class org.postgresql.util.PGtokenizer

This returns a new tokenizer based on one of our tokens.

tokens - Variable in class org.postgresql.util.PGtokenizer

toLong(String) - Static method in class org.postgresql.jdbc.PgResultSet

TOO_MANY_RESULTS - Static variable in class org.postgresql.util.PSQLState

toPGString(byte[]) - Static method in class org.postgresql.util.PGbytea

toString() - Method in class org.postgresql.core.CachedQuery

toString() - Method in class org.postgresql.core.Encoding

toString() - Method in class org.postgresql.core.Field

toString() - Method in enum org.postgresql.core.Keyword

toString(ParameterList) - Method in class org.postgresql.core.NativeQuery

Stringize this query to a human-readable form, substituting particular parameter values for parameter placeholders.

toString(int) - Static method in class org.postgresql.core.Oid

Returns the name of the oid as string.

toString(int, boolean) - Method in interface org.postgresql.core.ParameterList

Return a human-readable representation of a particular parameter in this ParameterList.

toString(ParameterList) - Method in interface org.postgresql.core.Query

Stringize this query to a human-readable form, substituting particular parameter values for parameter placeholders.

toString(ParameterList) - Method in class org.postgresql.core.v3.BatchedQuery

toString() - Method in class org.postgresql.jdbc.FieldMetadata.Key

toString() - Method in class org.postgresql.jdbc.FieldMetadata

toString() - Method in class org.postgresql.jdbc.PgArray

toString(Calendar, Timestamp) - Method in class org.postgresql.jdbc.TimestampUtils

toString(Calendar, Timestamp, boolean) - Method in class org.postgresql.jdbc.TimestampUtils

toString(Calendar, Date) - Method in class org.postgresql.jdbc.TimestampUtils

toString(Calendar, Date, boolean) - Method in class org.postgresql.jdbc.TimestampUtils

toString(Calendar, Time) - Method in class org.postgresql.jdbc.TimestampUtils

toString(Calendar, Time, boolean) - Method in class org.postgresql.jdbc.TimestampUtils

toString() - Method in class org.postgresql.util.HostSpec

toString(Map<?, ?>) - Static method in class org.postgresql.util.HStoreConverter

toString() - Method in class org.postgresql.util.PGobject

This is defined here, so user code need not overide it.

toString() - Method in exception org.postgresql.util.PSQLWarning

toString() - Method in class org.postgresql.util.ServerErrorMessage

toString() - Method in class org.postgresql.util.StreamWrapper

toTime(Calendar, String) - Method in class org.postgresql.jdbc.TimestampUtils

toTimeBin(TimeZone, byte[]) - Method in class org.postgresql.jdbc.TimestampUtils

Returns the SQL Time object matching the given bytes with Oid.TIME or Oid.TIMETZ.

toTimestamp(Calendar, String) - Method in class org.postgresql.jdbc.TimestampUtils

Parse a string and return a timestamp representing its value.

toTimestampBin(TimeZone, byte[], boolean) - Method in class org.postgresql.jdbc.TimestampUtils

Returns the SQL Timestamp object matching the given bytes with Oid.TIMESTAMP or Oid.TIMESTAMPTZ.

tr(String, Object...) - Static method in class org.postgresql.util.GT

TRANSACTION_STATE_INVALID - Static variable in class org.postgresql.util.PSQLState

TransactionState - Enum in org.postgresql.core

transformQueriesAndParameters() - Method in class org.postgresql.jdbc.PgStatement

translate(int, int) - Method in class org.postgresql.geometric.PGpoint

Translate the point by the supplied amount.

translate(double, double) - Method in class org.postgresql.geometric.PGpoint

Translate the point by the supplied amount.

truncate(long) - Method in class org.postgresql.jdbc.AbstractBlobClob

For Blobs this should be in bytes while for Clobs it should be in characters.

TRUNCATE - Static variable in class org.postgresql.jdbc.EscapedFunctions

truncate(int) - Method in class org.postgresql.largeobject.LargeObject

Truncates the large object to the given length in bytes.

truncate64(long) - Method in class org.postgresql.largeobject.LargeObject

Truncates the large object to the given length in bytes.

type - Variable in class org.postgresql.util.PGobject

TypeInfo - Interface in org.postgresql.core

TypeInfoCache - Class in org.postgresql.jdbc

TypeInfoCache(BaseConnection, int) - Constructor for class org.postgresql.jdbc.TypeInfoCache

typemap - Variable in class org.postgresql.jdbc.PgConnection

The current type mappings

TypeTransferModeRegistry - Interface in org.postgresql.core.v3

U

UCASE - Static variable in class org.postgresql.jdbc.EscapedFunctions

UNDEFINED_COLUMN - Static variable in class org.postgresql.util.PSQLState

UNDEFINED_FUNCTION - Static variable in class org.postgresql.util.PSQLState

UNDEFINED_OBJECT - Static variable in class org.postgresql.util.PSQLState

UNEXPECTED_ERROR - Static variable in class org.postgresql.util.PSQLState

UnixCrypt - Class in org.postgresql.util

Contains static methods to encrypt and compare passwords with Unix encrypted passwords.

UNKNOWN_STATE - Static variable in class org.postgresql.util.PSQLState

unlink(int) - Method in class org.postgresql.largeobject.LargeObjectManager

Deprecated. As of 8.3, replaced by LargeObjectManager.unlink(long)

unlink(long) - Method in class org.postgresql.largeobject.LargeObjectManager

This deletes a large object.

UNSPECIFIED - Static variable in class org.postgresql.core.Oid

unwrap(Class<T>) - Method in class org.postgresql.ds.PGPoolingDataSource

unwrap(Class<T>) - Method in class org.postgresql.ds.PGSimpleDataSource

unwrap(Class<T>) - Method in class org.postgresql.jdbc.PgConnection

unwrap(Class<T>) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

unwrap(Class<T>) - Method in class org.postgresql.jdbc.PgParameterMetaData

unwrap(Class<T>) - Method in class org.postgresql.jdbc.PgResultSet

unwrap(Class<T>) - Method in class org.postgresql.jdbc.PgResultSetMetaData

unwrap(Class<T>) - Method in class org.postgresql.jdbc.PgStatement

updateArray(int, Array) - Method in class org.postgresql.jdbc.PgResultSet

updateArray(String, Array) - Method in class org.postgresql.jdbc.PgResultSet

updateAsciiStream(int, InputStream, int) - Method in class org.postgresql.jdbc.PgResultSet

updateAsciiStream(String, InputStream, int) - Method in class org.postgresql.jdbc.PgResultSet

updateAsciiStream(int, InputStream, long) - Method in class org.postgresql.jdbc.PgResultSet

updateAsciiStream(String, InputStream, long) - Method in class org.postgresql.jdbc.PgResultSet

updateAsciiStream(int, InputStream) - Method in class org.postgresql.jdbc.PgResultSet

updateAsciiStream(String, InputStream) - Method in class org.postgresql.jdbc.PgResultSet

updateBigDecimal(int, BigDecimal) - Method in class org.postgresql.jdbc.PgResultSet

updateBigDecimal(String, BigDecimal) - Method in class org.postgresql.jdbc.PgResultSet

updateBinaryStream(int, InputStream, int) - Method in class org.postgresql.jdbc.PgResultSet

updateBinaryStream(String, InputStream, int) - Method in class org.postgresql.jdbc.PgResultSet

updateBinaryStream(int, InputStream, long) - Method in class org.postgresql.jdbc.PgResultSet

updateBinaryStream(String, InputStream, long) - Method in class org.postgresql.jdbc.PgResultSet

updateBinaryStream(int, InputStream) - Method in class org.postgresql.jdbc.PgResultSet

updateBinaryStream(String, InputStream) - Method in class org.postgresql.jdbc.PgResultSet

updateBlob(int, Blob) - Method in class org.postgresql.jdbc.PgResultSet

updateBlob(String, Blob) - Method in class org.postgresql.jdbc.PgResultSet

updateBlob(int, InputStream, long) - Method in class org.postgresql.jdbc.PgResultSet

updateBlob(String, InputStream, long) - Method in class org.postgresql.jdbc.PgResultSet

updateBlob(int, InputStream) - Method in class org.postgresql.jdbc.PgResultSet

updateBlob(String, InputStream) - Method in class org.postgresql.jdbc.PgResultSet

updateBoolean(int, boolean) - Method in class org.postgresql.jdbc.PgResultSet

updateBoolean(String, boolean) - Method in class org.postgresql.jdbc.PgResultSet

updateByte(int, byte) - Method in class org.postgresql.jdbc.PgResultSet

updateByte(String, byte) - Method in class org.postgresql.jdbc.PgResultSet

updateBytes(int, byte[]) - Method in class org.postgresql.jdbc.PgResultSet

updateBytes(String, byte[]) - Method in class org.postgresql.jdbc.PgResultSet

updateCharacterStream(int, Reader, int) - Method in class org.postgresql.jdbc.PgResultSet

updateCharacterStream(String, Reader, int) - Method in class org.postgresql.jdbc.PgResultSet

updateCharacterStream(int, Reader, long) - Method in class org.postgresql.jdbc.PgResultSet

updateCharacterStream(String, Reader, long) - Method in class org.postgresql.jdbc.PgResultSet

updateCharacterStream(int, Reader) - Method in class org.postgresql.jdbc.PgResultSet

updateCharacterStream(String, Reader) - Method in class org.postgresql.jdbc.PgResultSet

updateClob(int, Clob) - Method in class org.postgresql.jdbc.PgResultSet

updateClob(String, Clob) - Method in class org.postgresql.jdbc.PgResultSet

updateClob(int, Reader, long) - Method in class org.postgresql.jdbc.PgResultSet

updateClob(String, Reader, long) - Method in class org.postgresql.jdbc.PgResultSet

updateClob(int, Reader) - Method in class org.postgresql.jdbc.PgResultSet

updateClob(String, Reader) - Method in class org.postgresql.jdbc.PgResultSet

updateDate(int, Date) - Method in class org.postgresql.jdbc.PgResultSet

updateDate(String, Date) - Method in class org.postgresql.jdbc.PgResultSet

updateDouble(int, double) - Method in class org.postgresql.jdbc.PgResultSet

updateDouble(String, double) - Method in class org.postgresql.jdbc.PgResultSet

updateFloat(int, float) - Method in class org.postgresql.jdbc.PgResultSet

updateFloat(String, float) - Method in class org.postgresql.jdbc.PgResultSet

updateInt(int, int) - Method in class org.postgresql.jdbc.PgResultSet

updateInt(String, int) - Method in class org.postgresql.jdbc.PgResultSet

updateLong(int, long) - Method in class org.postgresql.jdbc.PgResultSet

updateLong(String, long) - Method in class org.postgresql.jdbc.PgResultSet

updateNCharacterStream(int, Reader, int) - Method in class org.postgresql.jdbc.PgResultSet

updateNCharacterStream(String, Reader, int) - Method in class org.postgresql.jdbc.PgResultSet

updateNCharacterStream(int, Reader) - Method in class org.postgresql.jdbc.PgResultSet

updateNCharacterStream(String, Reader) - Method in class org.postgresql.jdbc.PgResultSet

updateNCharacterStream(int, Reader, long) - Method in class org.postgresql.jdbc.PgResultSet

updateNCharacterStream(String, Reader, long) - Method in class org.postgresql.jdbc.PgResultSet

updateNClob(int, NClob) - Method in class org.postgresql.jdbc.PgResultSet

updateNClob(String, NClob) - Method in class org.postgresql.jdbc.PgResultSet

updateNClob(int, Reader) - Method in class org.postgresql.jdbc.PgResultSet

updateNClob(String, Reader) - Method in class org.postgresql.jdbc.PgResultSet

updateNClob(int, Reader, long) - Method in class org.postgresql.jdbc.PgResultSet

updateNClob(String, Reader, long) - Method in class org.postgresql.jdbc.PgResultSet

updateNString(int, String) - Method in class org.postgresql.jdbc.PgResultSet

updateNString(String, String) - Method in class org.postgresql.jdbc.PgResultSet

updateNull(int) - Method in class org.postgresql.jdbc.PgResultSet

updateNull(String) - Method in class org.postgresql.jdbc.PgResultSet

updateObject(int, Object) - Method in class org.postgresql.jdbc.PgResultSet

updateObject(int, Object, int) - Method in class org.postgresql.jdbc.PgResultSet

updateObject(String, Object, int) - Method in class org.postgresql.jdbc.PgResultSet

updateObject(String, Object) - Method in class org.postgresql.jdbc.PgResultSet

updateRef(int, Ref) - Method in class org.postgresql.jdbc.PgResultSet

updateRef(String, Ref) - Method in class org.postgresql.jdbc.PgResultSet

updateRow() - Method in class org.postgresql.jdbc.PgResultSet

updateRowId(int, RowId) - Method in class org.postgresql.jdbc.PgResultSet

updateRowId(String, RowId) - Method in class org.postgresql.jdbc.PgResultSet

updatesAreDetected(int) - Method in class org.postgresql.jdbc.PgDatabaseMetaData

updateShort(int, short) - Method in class org.postgresql.jdbc.PgResultSet

updateShort(String, short) - Method in class org.postgresql.jdbc.PgResultSet

updateSQLXML(int, SQLXML) - Method in class org.postgresql.jdbc.PgResultSet

updateSQLXML(String, SQLXML) - Method in class org.postgresql.jdbc.PgResultSet

updateString(int, String) - Method in class org.postgresql.jdbc.PgResultSet

updateString(String, String) - Method in class org.postgresql.jdbc.PgResultSet

updateTime(int, Time) - Method in class org.postgresql.jdbc.PgResultSet

updateTime(String, Time) - Method in class org.postgresql.jdbc.PgResultSet

updateTimestamp(int, Timestamp) - Method in class org.postgresql.jdbc.PgResultSet

updateTimestamp(String, Timestamp) - Method in class org.postgresql.jdbc.PgResultSet

updateValue(int, Object) - Method in class org.postgresql.jdbc.PgResultSet

useBinaryForReceive(int) - Method in class org.postgresql.core.v3.QueryExecutorImpl

useBinaryForReceive(int) - Method in interface org.postgresql.core.v3.TypeTransferModeRegistry

Returns if given oid should be received in binary format

useBinaryForSend(int) - Method in class org.postgresql.core.v3.QueryExecutorImpl

useBinaryForSend(int) - Method in interface org.postgresql.core.v3.TypeTransferModeRegistry

Returns if given oid should be sent in binary format

USER - Static variable in class org.postgresql.jdbc.EscapedFunctions

usesLocalFilePerTable() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Does the database use a file for each table?

usesLocalFiles() - Method in class org.postgresql.jdbc.PgDatabaseMetaData

Does the database store tables in a local file?

Utils - Class in org.postgresql.core

Collection of utilities used by the protocol-level code.

Utils() - Constructor for class org.postgresql.core.Utils

UUID - Static variable in class org.postgresql.core.Oid

UUID_ARRAY - Static variable in class org.postgresql.core.Oid

UUIDArrayAssistant - Class in org.postgresql.jdbc

UUIDArrayAssistant() - Constructor for class org.postgresql.jdbc.UUIDArrayAssistant

V

val - Variable in class org.postgresql.util.PGmoney

value() - Method in enum org.postgresql.jdbc.AutoSave

value() - Method in enum org.postgresql.jdbc.PreferQueryMode

value - Variable in class org.postgresql.util.PGobject

valueOf(String) - Static method in enum org.postgresql.core.Keyword

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in class org.postgresql.core.Oid

valueOf(String) - Static method in enum org.postgresql.core.ServerVersion

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.postgresql.core.SqlCommandType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.postgresql.core.TransactionState

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.postgresql.hostchooser.HostRequirement

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.postgresql.hostchooser.HostStatus

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.postgresql.jdbc.AutoSave

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.postgresql.jdbc.PreferQueryMode

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.postgresql.PGProperty

Returns the enum constant of this type with the specified name.

values() - Static method in enum org.postgresql.core.Keyword

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.postgresql.core.ServerVersion

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.postgresql.core.SqlCommandType

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.postgresql.core.TransactionState

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.postgresql.hostchooser.HostRequirement

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.postgresql.hostchooser.HostStatus

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.postgresql.jdbc.AutoSave

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.postgresql.jdbc.PreferQueryMode

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.postgresql.PGProperty

Returns an array containing the constants of this enum type, in the order they are declared.

VARBIT - Static variable in class org.postgresql.core.Oid

VARBIT_ARRAY - Static variable in class org.postgresql.core.Oid

VARCHAR - Static variable in class org.postgresql.core.Oid

VARCHAR_ARRAY - Static variable in class org.postgresql.core.Oid

verify(String, SSLSession) - Method in class org.postgresql.ssl.jdbc4.LibPQFactory

Verifies the server certificate according to the libpq rules.

Version - Interface in org.postgresql.core

VisibleBufferedInputStream - Class in org.postgresql.core

A faster version of BufferedInputStream.

VisibleBufferedInputStream(InputStream, int) - Constructor for class org.postgresql.core.VisibleBufferedInputStream

Creates a new buffer around the given stream.

VOID - Static variable in class org.postgresql.core.Oid

W

wantsGeneratedKeysAlways - Variable in class org.postgresql.jdbc.PgStatement

Was this PreparedStatement created to return generated keys for every execution?

wantsGeneratedKeysOnce - Variable in class org.postgresql.jdbc.PgStatement

Does the caller of execute/executeUpdate want generated keys for this execution?

wantsHoldableResultSet() - Method in class org.postgresql.jdbc.PgStatement

wantsScrollableResultSet() - Method in class org.postgresql.jdbc.PgStatement

warnings - Variable in class org.postgresql.jdbc.PgResultSet

warnings - Variable in class org.postgresql.jdbc.PgStatement

The warnings chain.

wasNull() - Method in class org.postgresql.jdbc.PgResultSet

wasNullFlag - Variable in class org.postgresql.jdbc.PgResultSet

True if the last obtained column value was SQL NULL as specified by PgResultSet.wasNull().

WEEK - Static variable in class org.postgresql.jdbc.EscapedFunctions

willHealOnRetry(SQLException) - Method in interface org.postgresql.core.QueryExecutor

willHealOnRetry(SQLException) - Method in class org.postgresql.core.QueryExecutorBase

willHealViaReparse(SQLException) - Method in class org.postgresql.core.QueryExecutorBase

wrap(List<NativeQuery>) - Method in interface org.postgresql.core.QueryExecutor

Wrap given native query into a ready for execution format

wrap(List<NativeQuery>) - Method in class org.postgresql.core.v3.QueryExecutorImpl

WrappedFactory - Class in org.postgresql.ssl

Provide a wrapper to a real SSLSocketFactory delegating all calls to the contained instance.

WrappedFactory() - Constructor for class org.postgresql.ssl.WrappedFactory

write(int) - Method in class org.postgresql.copy.PGCopyOutputStream

write(byte[]) - Method in class org.postgresql.copy.PGCopyOutputStream

write(byte[], int, int) - Method in class org.postgresql.copy.PGCopyOutputStream

write(int) - Method in class org.postgresql.largeobject.BlobOutputStream

write(byte[], int, int) - Method in class org.postgresql.largeobject.BlobOutputStream

write(byte[]) - Method in class org.postgresql.largeobject.LargeObject

Writes an array to the object

write(byte[], int, int) - Method in class org.postgresql.largeobject.LargeObject

Writes some data from an array to the object

WRITE - Static variable in class org.postgresql.largeobject.LargeObjectManager

This mode indicates we want to write to an object

writeBaseObject(ObjectOutputStream) - Method in class org.postgresql.ds.common.BaseDataSource

writeToCopy(byte[], int, int) - Method in interface org.postgresql.copy.CopyIn

Writes specified part of given byte array to an open and writable copy operation.

writeToCopy(byte[], int, int) - Method in class org.postgresql.copy.PGCopyOutputStream

writeToCopy(byte[], int, int) - Method in class org.postgresql.core.v3.CopyInImpl

writeToCopy(CopyInImpl, byte[], int, int) - Method in class org.postgresql.core.v3.QueryExecutorImpl

Sends data during a live COPY IN operation.

WRONG_OBJECT_TYPE - Static variable in class org.postgresql.util.PSQLState

X

x - Variable in class org.postgresql.geometric.PGpoint

The X coordinate of the point

XML - Static variable in class org.postgresql.core.Oid

XML_ARRAY - Static variable in class org.postgresql.core.Oid

Y

y - Variable in class org.postgresql.geometric.PGpoint

The Y coordinate of the point

YEAR - Static variable in class org.postgresql.jdbc.EscapedFunctions

_

_factory - Variable in class org.postgresql.ssl.WrappedFactory

A B C D E F G H I J K L M N O P Q R S T U V W X Y _