Generate column from another column postgresql

CREATE TABLE IF NOT EXISTS "Organizations" (
  "id" SERIAL,
  "name" VARCHAR(255),
  "lowercaseName" VARCHAR(255) GENERATED ALWAYS AS (LOWER("name")) STORED,
  
  PRIMARY KEY("id"),
  UNIQUE("lowercaseName")
);

CREATE TABLE IF NOT EXISTS "Organizations" (
  "id" SERIAL,
  "name" VARCHAR(255),
  "lowercaseName" VARCHAR(255) GENERATED ALWAYS AS (LOWER("name")) STORED,
  
  PRIMARY KEY("id"),
  UNIQUE("lowercaseName")
);

CREATE TABLE IF NOT EXISTS "Organizations" (
  "id" SERIAL,
  "name" VARCHAR(255),
  "lowercaseName" VARCHAR(255) GENERATED ALWAYS AS (LOWER("name")) STORED,
  
  PRIMARY KEY("id"),
  UNIQUE("lowercaseName")
);

CREATE TABLE IF NOT EXISTS "Organizations" (
  "id" SERIAL,
  "name" VARCHAR(255),
  "lowercaseName" VARCHAR(255) GENERATED ALWAYS AS (LOWER("name")) STORED,
  
  PRIMARY KEY("id"),
  UNIQUE("lowercaseName")
);

Hi guys, I've been watching the docs and the discord server for quite some time and I haven't been able to find instructions about this use case using drizzle.

Thank you

Generate column from another column postgresql

Similar Threads

Similar Threads

Similar Threads