code: public static final int getSQLType(final String typeName) {
          String trimmedTypeName = typeName.trim().toLowerCase(Locale.US);
          final Integer n = pgGenericTypeNameToSQLTypeMap.get(trimmedTypeName);
          if (n == null) {
  
              // look up the alias
              trimmedTypeName = pgGenericTypeNameAliasMap.get(trimmedTypeName);
              if (trimmedTypeName != null) {
                  return pgGenericTypeNameToSQLTypeMap.get(trimmedTypeName);
              }
  
              return Types.OTHER;
          } else {
              return n;
          }
      }
docs: A simple method to get an appropriate java.sql.types.* value for the given PostgreSQL type name
  
  @param   typeName
  
  @return  SQL type