Interface TypeInfo

  • All Known Implementing Classes:
    TypeInfoCache

    public interface TypeInfo
    • 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<? extends PGobject> 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 - if an error occurs when retrieving sql type
      • 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 - if an error occurs when retrieving sql type
      • 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 - if an error occurs when retrieving PG type
      • 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 - if an error occurs when retrieving PG type
      • 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 - if an error occurs when retrieving array element
      • 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 - if an error occurs when retrieving array type
      • 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 - if an error occurs when retrieving array delimiter
      • getPGTypeNamesWithSQLTypes

        java.util.Iterator<java.lang.String> getPGTypeNamesWithSQLTypes()
      • getPGTypeOidsWithSQLTypes

        java.util.Iterator<java.lang.Integer> getPGTypeOidsWithSQLTypes()
      • getPGobject

        java.lang.Class<? extends PGobject> 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
      • requiresQuotingSqlType

        boolean requiresQuotingSqlType​(int sqlType)
                                throws java.sql.SQLException
        Returns true if particular sqlType requires quoting. This method is used internally by the driver, so it might disappear without notice.
        Parameters:
        sqlType - sql type as in java.sql.Types
        Returns:
        true if the type requires quoting
        Throws:
        java.sql.SQLException - if something goes wrong