DT
Drizzle Team•9mo ago
Emirhan

How to update "updated_at" column automaticly when related row is updated?

Hello. I'm using PostgreSQL as a dbms. So driver is pg. I want to update the "updated_at" column when the row is updated. Is this implementation is ok for the feature.
const updated_at = timestamp("updated_at")
  .notNull()
  .defaultNow()
  .$onUpdateFn(() => sql`now()`);
const updated_at = timestamp("updated_at")
  .notNull()
  .defaultNow()
  .$onUpdateFn(() => sql`now()`);
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?