Migration: Difference between revisions
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
{| class="wikitable" | {| class="wikitable" | ||
! || Postgres || MariaDB | ! || Postgres || MariaDB | ||
|- | |- | ||
| Incremental | | Incremental | ||
| Line 20: | Line 20: | ||
| <source lang="sql"> | | <source lang="sql"> | ||
auto incremental | auto incremental | ||
</source> | |||
| Text with emoji | |||
| <source lang="sql"> | |||
</source> | </source> | ||
| | | | ||
Revision as of 03:40, 1 September 2025
Table
Column
Data Types
| Postgres | MariaDB | ||||
|---|---|---|---|---|---|
| Incremental | CREATE TABLE public.test (
id1 serial8 NOT NULL,
id2 int8 GENERATED ALWAYS AS IDENTITY NOT NULL,
id3 int8 GENERATED BY DEFAULT AS IDENTITY NOT NULL
);
|
auto incremental
|
Text with emoji | ||
| DateTime |