org.postgresql.core

Interface TypeInfo

All Known Implementing Classes:

TypeInfoCache

public interface TypeInfo

Method Summary

Methods

Modifier and Type	Method and Description
void	addCoreType(java.lang.String pgTypeName, java.lang.Integer oid, java.lang.Integer sqlType, java.lang.String javaClass, java.lang.Integer arrayOid)
void	addDataType(java.lang.String type, java.lang.Class klass)
char	getArrayDelimiter(int oid) Determine the delimiter for the elements of the given array type oid.
int	getDisplaySize(int oid, int typmod)
java.lang.String	getJavaClass(int oid)
int	getMaximumPrecision(int oid)
int	getPGArrayElement(int oid) Look up the oid of an array's base type given the array's type oid.
int	getPGArrayType(java.lang.String elementTypeName) Determine the oid of the given base postgresql type's array type
java.lang.Class	getPGobject(java.lang.String type)
java.lang.String	getPGType(int oid) Look up the postgresql type name for a given oid.
int	getPGType(java.lang.String pgTypeName) Look up the oid for a given postgresql type name.
java.util.Iterator	getPGTypeNamesWithSQLTypes()
int	getPrecision(int oid, int typmod)
int	getScale(int oid, int typmod)
int	getSQLType(int oid) Look up the SQL typecode for a given type oid.
int	getSQLType(java.lang.String pgTypeName) Look up the SQL typecode for a given postgresql type name.
java.lang.String	getTypeForAlias(java.lang.String alias)
boolean	isCaseSensitive(int oid)
boolean	isSigned(int oid)
boolean	requiresQuoting(int oid)

Method Detail

addCoreType

void addCoreType(java.lang.String pgTypeName,
               java.lang.Integer oid,
               java.lang.Integer sqlType,
               java.lang.String javaClass,
               java.lang.Integer arrayOid)

addDataType

void addDataType(java.lang.String type,
               java.lang.Class klass)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getSQLType

int getSQLType(int oid)
               throws java.sql.SQLException

Look up the SQL typecode for a given type oid.

Parameters:

oid - the type's OID

Returns:

the SQL type code (a constant from Types) for the type

Throws:

java.sql.SQLException

getSQLType

int getSQLType(java.lang.String pgTypeName)
               throws java.sql.SQLException

Look up the SQL typecode for a given postgresql type name.

Parameters:

pgTypeName - the server type name to look up

Returns:

the SQL type code (a constant from Types) for the type

Throws:

java.sql.SQLException

getPGType

int getPGType(java.lang.String pgTypeName)
              throws java.sql.SQLException

Look up the oid for a given postgresql type name. This is the inverse of getPGType(int).

Parameters:

pgTypeName - the server type name to look up

Returns:

the type's OID, or 0 if unknown

Throws:

java.sql.SQLException

getPGType

java.lang.String getPGType(int oid)
                           throws java.sql.SQLException

Look up the postgresql type name for a given oid. This is the inverse of getPGType(String).

Parameters:

oid - the type's OID

Returns:

the server type name for that OID or null if unknown

Throws:

java.sql.SQLException

getPGArrayElement

int getPGArrayElement(int oid)
                      throws java.sql.SQLException

Look up the oid of an array's base type given the array's type oid.

Parameters:

oid - the array type's OID

Returns:

the base type's OID, or 0 if unknown

Throws:

java.sql.SQLException

getPGArrayType

int getPGArrayType(java.lang.String elementTypeName)
                   throws java.sql.SQLException

Determine the oid of the given base postgresql type's array type

Parameters:

elementTypeName - the base type's

Returns:

the array type's OID, or 0 if unknown

Throws:

java.sql.SQLException

getArrayDelimiter

char getArrayDelimiter(int oid)
                       throws java.sql.SQLException

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

Parameters:

oid - the array type's OID

Returns:

the base type's array type delimiter

Throws:

java.sql.SQLException

getPGTypeNamesWithSQLTypes

java.util.Iterator getPGTypeNamesWithSQLTypes()

getPGobject

java.lang.Class getPGobject(java.lang.String type)

getJavaClass

java.lang.String getJavaClass(int oid)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getTypeForAlias

java.lang.String getTypeForAlias(java.lang.String alias)

getPrecision

int getPrecision(int oid,
               int typmod)

getScale

int getScale(int oid,
           int typmod)

isCaseSensitive

boolean isCaseSensitive(int oid)

isSigned

boolean isSigned(int oid)

getDisplaySize

int getDisplaySize(int oid,
                 int typmod)

getMaximumPrecision

int getMaximumPrecision(int oid)

requiresQuoting

boolean requiresQuoting(int oid)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException