Emirhan
Emirhan
PostsComments
DTDrizzle Team
Created by Emirhan on 4/22/2024 in #help
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()`);
1 replies