phinx icon indicating copy to clipboard operation
phinx copied to clipboard

Identity Column support for PostgreSQL

Open romanzks opened this issue 3 years ago • 2 comments

It would be great to be able to create tables with an Identity Column.

The old PostgreSQL approach for creating identifiers:

CREATE TABLE test_old (
    id serial PRIMARY KEY,
    payload text
);

The new PostgreSQL approach for creating identifiers:

CREATE TABLE test_new (
    id int GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    payload text
);

romanzks avatar Feb 12 '22 20:02 romanzks

@romanzks Resolved in MR #2085 . Pending review and merge

ajibarra avatar Apr 29 '22 09:04 ajibarra

Would be great to have this reviewed / merged

swiffer avatar Jul 03 '22 17:07 swiffer

Since it has been merged already it looks the issue can be closed

ajibarra avatar May 12 '23 07:05 ajibarra