Migration: Difference between revisions
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
|- | |- | ||
| Incremental | | Incremental | ||
| < | | <syntaxhighlight lang="sql"> | ||
CREATE TABLE public.test ( | CREATE TABLE public.test ( | ||
id1 serial8 NOT NULL, | id1 serial8 NOT NULL, | ||
| Line 17: | Line 17: | ||
id3 int8 GENERATED BY DEFAULT AS IDENTITY NOT NULL | id3 int8 GENERATED BY DEFAULT AS IDENTITY NOT NULL | ||
); | ); | ||
</ | </syntaxhighlight> | ||
| < | | <syntaxhighlight lang="sql"> | ||
auto incremental | auto incremental | ||
</ | </syntaxhighlight> | ||
|- | |- | ||
| Text with emoji | | Text with emoji | ||
| < | | <syntaxhighlight lang="sql"> | ||
</ | </syntaxhighlight> | ||
| | | | ||
|- | |- | ||
Revision as of 03:41, 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 |