How to define "INT GENERATED ALWAYS AS IDENTITY" column with node-pg-migrate?

Question

How do I define a migration file using node-pg-migrate for the below table

CREATE TABLE color (
    color_id INT GENERATED ALWAYS AS IDENTITY,
    color_name VARCHAR NOT NULL
);

There seems to be no documentation on how to do INT GENERATED ALWAYS AS INDENTITY column using node-pg-migrate

or even generated by default as identity – PirateApp Dec 08 '21 at 14:25 — PirateApp, Dec 08 '21 at 14:25

score 1 · Accepted Answer · answered Dec 29 '22 at 16:09

I haven't checked the history or when sequenceGenerated has been added, but at least at the time of writing the SQL you seek for can be generated with

pgm.createTable(
  'color',
  {
    color_id: {
      type: 'integer',
      sequenceGenerated: {
        precedence: 'ALWAYS'
      }
    },
    color_name: {
      type: 'varchar',
      notNull: true
    }
  }
)

This will create a migration with SQL

CREATE TABLE "color" (
  "color_id" integer GENERATED ALWAYS AS IDENTITY,
  "color_name" varchar NOT NULL
);

How to define "INT GENERATED ALWAYS AS IDENTITY" column with node-pg-migrate?

1 Answers1