erichard/postgresql-doctrine-type

Doctrine implementation of some useful PostgreSQL data types

PostgreSQL Doctrine Type

This library add support for useful postgresql types such as Point, DateRange or Arrays., _(*1)

Usage

In Symfony, you only need to update your DBAL config., _(*2)

doctrine:
    dbal:
        types:
            jsonb: PostgreSQLDoctrineType\DBAL\Type\JsonType
            daterange: PostgreSQLDoctrineType\DBAL\Type\DateRangeType
            tsrange: PostgreSQLDoctrineType\DBAL\Type\TsRangeType
            varchar_array: PostgreSQLDoctrineType\DBAL\Type\VarcharArrayType
        mapping_types:
            json_array: jsonb  # redefine doctrine json_array to use jsonb
            daterange: daterange
            tsrange: tsrange