> For the complete documentation index, see [llms.txt](https://l-shop-en.gitbook.io/documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://l-shop-en.gitbook.io/documentation/configuration/postgresql-configuration.md).

# Configuration for PostgreSQL

All you need to do is to uncomment lines *139-142* in the element of the array `custom_datetime_functions` in the `/config/doctrine.php` file and remove (comment out) lines *133-136*.

Before:

{% code title="/config/doctrine.php" %}

```php
    'custom_datetime_functions' => [
//      For MySQL:
        'DATE_FORMAT' => \DoctrineExtensions\Query\Mysql\DateFormat::class,
        'YEAR' => \DoctrineExtensions\Query\Mysql\Year::class,
        'MONTH' => \DoctrineExtensions\Query\Mysql\Month::class,
        'DAY' => \DoctrineExtensions\Query\Mysql\Day::class
​
//        For PostgreSQL:
//        'DATE_FORMAT' => \DoctrineExtensions\Query\Postgresql\DateFormat::class,
//        'YEAR' => \App\Services\Database\Query\Postgresql\Year::class,
//        'MONTH' => \App\Services\Database\Query\Postgresql\Month::class,
//        'DAY' => \App\Services\Database\Query\Postgresql\Day::class
    ],

```

{% endcode %}

After:

{% code title="/config/doctrine.php" %}

```php
    'custom_datetime_functions' => [
//        For MySQL:
//        'DATE_FORMAT' => \DoctrineExtensions\Query\Mysql\DateFormat::class,
//        'YEAR' => \DoctrineExtensions\Query\Mysql\Year::class,
//        'MONTH' => \DoctrineExtensions\Query\Mysql\Month::class,
//        'DAY' => \DoctrineExtensions\Query\Mysql\Day::class
​
//      For PostgreSQL:
        'DATE_FORMAT' => \DoctrineExtensions\Query\Postgresql\DateFormat::class,
        'YEAR' => \App\Services\Database\Query\Postgresql\Year::class,
        'MONTH' => \App\Services\Database\Query\Postgresql\Month::class,
        'DAY' => \App\Services\Database\Query\Postgresql\Day::class
    ],
```

{% endcode %}