iterate a column in all tables postgre

migration.js

import db from './src/db'

const af = async () => {
  const res = await db.raw(
    `SELECT tablename FROM pg_tables WHERE schemaname='looop'`
  )

  console.log('res: ', res)
  res.rows.forEach(async table => {
    const { tablename } = table

    const schema = await db.raw(
      `select *
      from ${tablename}
      where false;`
    )
    const fields = schema.fields.map(({ name }) => name)
    if (fields.includes('updated_at')) {
      console.log(tablename)
      await db.schema.table(tablename, table => {
        table
          .timestamp('updated_at')
          .nullable()
          .alter()
      })
    }
  })
}

af()