TypeORM - appending new items to array-type column (Postgres)

Question

Postgres supports array type columns, and exposes methods for working with those arrays (like array_append). I'm wondering if TypeORM allows using those methods somehow.

In case it's not supported, what do you think the best way to append items to PG array? Doing something like get-and-set? (a transaction of getting the value, creating the new new array with js, and updating the value in the DB)

Bob Singor · Accepted Answer · 2022-03-30 10:02:04Z

4

You can use native Postgres methods like array_append if you use the TypeORM Query Builder.

Example below:

await dataSource.createQueryBuilder()
  .update(User)
  .set({
    yourArrayColumn: () => `array_append("yourArrayColumn", 1)`
  })
  .where("id = :id", { id: 1 })
  .execute();

More about using TypeORM Query Builder for updates: https://typeorm.io/update-query-builder

answered Mar 30, 2022 at 10:02

Bob Singor

5761 gold badge5 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

TypeORM - appending new items to array-type column (Postgres)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related