https://www.sqlines.com/ 2026-05-30T13:31:05+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2022-10-20T21:27:04+00:00 https://www.sqlines.com/postgresql-to-mariadb/identity?rev=1666301224&do=diff IDENTITY column property allows you to automatically generate sequential integer numbers (IDs) for a column. IDENTITY columns are available since PostgreSQL 10. In MariaDB you can use AUTO_INCREMENT column property. Note that you can use the AUTO_INCREMENT table property to define the start value, but you cannot specify the increment step, it is always 1. text/html 2025-10-22T12:52:28+00:00 https://www.sqlines.com/postgresql-to-mariadb/timestamp_with_time_zone?rev=1761137548&do=diff In PostgreSQL, the TIMESTAMP WITH TIME ZONE data type stores datetime with time zone information. MariaDB does not provide a data type for storing values with different time zones. You can use the DATETIME data type and convert PostgreSQL values to UTC (or any other single time zone) so that all values are stored consistently in the same time zone.