6 replies

How to add comment on postgres table columns (and other one-time operations like add trigger)

🛠️drizzle kitPostgreSQLnode-postgres

I want to add comment on columns of my postgres table (

COMMENT ON COLUMN

COMMENT ON COLUMN

). There is no native function in drizzle.
I can see suggestions like

export default {
  async up(db) {
    await db.execute(sql`COMMENT ON COLUMN users.username IS 'User\'s unique username';`);
    await db.execute(sql`COMMENT ON COLUMN users.email IS 'User\'s email address';`);
  },

export default {
  async up(db) {
    await db.execute(sql`COMMENT ON COLUMN users.username IS 'User\'s unique username';`);
    await db.execute(sql`COMMENT ON COLUMN users.email IS 'User\'s email address';`);
  },

But won't this be executed every time? I faced same doubt when trying to add trigger+function.

Drizzle Team•15mo ago•

6 replies

How to add comment on postgres table columns (and other one-time operations like add trigger)

🛠️drizzle kitPostgreSQLnode-postgres

I want to add comment on columns of my postgres table (

COMMENT ON COLUMN

COMMENT ON COLUMN

). There is no native function in drizzle.
I can see suggestions like

export default {
  async up(db) {
    await db.execute(sql`COMMENT ON COLUMN users.username IS 'User\'s unique username';`);
    await db.execute(sql`COMMENT ON COLUMN users.email IS 'User\'s email address';`);
  },

export default {
  async up(db) {
    await db.execute(sql`COMMENT ON COLUMN users.username IS 'User\'s unique username';`);
    await db.execute(sql`COMMENT ON COLUMN users.email IS 'User\'s email address';`);
  },

But won't this be executed every time? I faced same doubt when trying to add trigger+function.

How to add comment on postgres table columns (and other one-time operations like add trigger)

Similar Threads

How to add comment on postgres table columns (and other one-time operations like add trigger)

Similar Threads

Similar Threads

Similar Threads