public ClobType(Dialect dialect) {
	super(new VarcharTypeDescriptor() {
		@Override
		public int getSqlType() {
			//force the use of byte instead of oid on Postgres
			return dialect instanceof PostgreSQL10Dialect
					? Types.LONGVARCHAR
					: Types.CLOB;
		}

		@Override
		public boolean canBeRemapped() {
			return false;
		}
	}, StringTypeDescriptor.INSTANCE);
}
 

public BlobType(Dialect dialect) {
	super(new VarbinaryTypeDescriptor() {
		@Override
		public int getSqlType() {
			//force the use of text instead of oid on Postgres
			return dialect instanceof PostgreSQL10Dialect
					? Types.LONGVARBINARY
					: Types.BLOB;
		}

		@Override
		public boolean canBeRemapped() {
			return false;
		}
	}, PrimitiveByteArrayTypeDescriptor.INSTANCE);
}