[postgres] migration_diff, "timestamptimezone" is not a valid column option

[Rakasch]

I run cakephp 5.2.9 with a postgres DB (postgresSQL 18.1).

I added a new 'created' column with type timestamptz to a table :

I generated a new migration file with the bake tool.

bin/cake bake migration_diff ...

The generated migation has this code in the up function:

            ->addColumn('created', 'timestamptimezone', [
                'default' => null,
                'limit' => null,
                'null' => true,
                'precision' => 6,
                'scale' => 6,
            ])

When I try to use the migration

bin/cake migrations migrate

I get the following error: An invalid column type "timestamptimezone" was specified for column "created".

I tried to manually change it to something else.
"timestamptz" is also an invalid option.
With "timestamp", the migration can be executed but creates a column with timestamp(6).

First: What is the value for the migration to generate a timestamptz column?
Second: Would be nice, if the migration_diff would be updated to use that / or the migrate to use timestamptimezone correctly

---

I also noticed something maybe related, when i checked the other migrations.
In my initial snapshot, all timestamptz columns in my database were transferred to the migration as type ‘timestamp’, so without the timezone.

bin/cake bake migration_snapshot Initial

---

Versions:
"cakephp/cakephp": 5.2.9
"cakephp/migrations": 4.9.1
"cakephp/plugin-installer": 2.0.1
"cnizzardini/cakephp-swagger-bake": 3.3.4
"cakephp/bake": 3.5.1
"cakephp/cakephp-codesniffer": 5.3.0
"cakephp/debug_kit": 5.2.1
"dereuromark/cakephp-ide-helper": 2.14.0