An extension driver to the postgresql Database to support materialized views.
- CakePHP 4.0+
- PHP 7.2+
composer require felipevr/postgresql-ext
Use
Edit your config/app.php
use Fvr\Database\Driver\NewPostgres;
...
return [
...
'Datasources' => [
'default' => [
'className' => 'Cake\Database\Connection',
'driver' => `'Fvr\Database\Driver\NewPostgres'`,
...
],
'test' => [
'className' => Connection::class,
'driver' => NewPostgres::class,
...
],
],
...
];