class PostgresDbmsMetadataHandler extends AbstractDbmsMetadataHandler {

    PostgresDbmsMetadataHandler(
        final ConnectionPoolComponent connectionPoolComponent,
        final DbmsHandlerComponent dbmsHandlerComponent,
        final ProjectComponent projectComponent
    ) {
        super(connectionPoolComponent, dbmsHandlerComponent, projectComponent);
    }

    @Override
    protected JavaTypeMap newJavaTypeMap() {
        final JavaTypeMap javaTypeMap = super.newJavaTypeMap();

        javaTypeMap.put("bytea", Blob.class);

        // https://www.postgresql.org/docs/9.2/static/infoschema-datatypes.html
        javaTypeMap.put("cardinal_number", Integer.class);
        javaTypeMap.put("character_data", String.class);
        javaTypeMap.put("sql_identifier", String.class);
        javaTypeMap.put("time_stamp", Timestamp.class);
        javaTypeMap.put("yes_or_no", String.class);

        javaTypeMap.put("json", String.class);
        javaTypeMap.put("jsonb", String.class);

        javaTypeMap.addRule(bitRule());

        javaTypeMap.addRule(yearRule());

        javaTypeMap.addRule(stringRule("_text", 2003));

        javaTypeMap.addRule(stringRule("tsvector", 1111));

        return javaTypeMap;
    }

    private JavaTypeMap.Rule stringRule(String text, int i) {<FILL_FUNCTION_BODY>}

    private JavaTypeMap.Rule yearRule() {
        return (sqlTypeMapping, md) -> {
            if ("year".equalsIgnoreCase(md.getTypeName()) && md.getDataType() == 2001) {
                return Optional.of(Integer.class);
            } else return Optional.empty();
        };
    }

    private JavaTypeMap.Rule bitRule() {
        return (sqlTypeMapping, md) -> {
            // Map a BIT(1) to boolean
            if ("BIT".equalsIgnoreCase(md.getTypeName()) && md.getColumnSize() == 1) {
                return Optional.of(Boolean.class);
            } else return Optional.empty();
        };
    }

    @Override
    protected void setAutoIncrement(Column column, ColumnMetaData md) throws SQLException {
        super.setAutoIncrement(column, md);
        final String defaultValue = md.getColumnDef();
        if (defaultValue != null && defaultValue.startsWith("nextval(")) {
            column.mutator().setAutoIncrement(true);
        }
    }

}

        return (sqlTypeMapping, md) -> {
            if (text.equalsIgnoreCase(md.getTypeName()) && md.getDataType() == i) {
                return Optional.of(String.class);
            } else return Optional.empty();
        };
    
<methods>public java.lang.String getDbmsInfoString(com.speedment.runtime.config.Dbms) throws java.sql.SQLException,public CompletableFuture<com.speedment.runtime.config.Project> readSchemaMetadata(com.speedment.runtime.config.Dbms, com.speedment.runtime.core.util.ProgressMeasure, Predicate<java.lang.String>) <variables>private static final Class<?> DEFAULT_MAPPING,public static final boolean EXTRA_INFO,private static final com.speedment.common.logger.Logger LOGGER,public static final boolean SHOW_METADATA,private final non-sealed com.speedment.runtime.core.component.connectionpool.ConnectionPoolComponent connectionPoolComponent,private final non-sealed com.speedment.runtime.core.component.DbmsHandlerComponent dbmsHandlerComponent,private final non-sealed com.speedment.runtime.core.db.JavaTypeMap javaTypeMap,private final non-sealed com.speedment.runtime.core.component.ProjectComponent projectComponent,private final non-sealed Map<Class<? extends com.speedment.runtime.config.Document>,java.util.concurrent.atomic.AtomicLong> timers