int,
name text
fcm_token text[]
status character varying(20)
}
There is table like above. Table data below:
userdb=# select * from user;
- [ RECORD 1 ] ———————
id | 10
name | Taki Takuya
fcm_token | {string}
status | offline
- [ RECORD 2 ] ———————
id | 20
name | Raj Chaudhari
fcm_token | {string}
status | online
- [ RECORD 3 ] ———————
id | 30
name | John Black
fcm_token | {string}
status | busy
QUESTION: How to UPDATE table's fcm_token field through adding array of string and change it?
https://www.postgresql.org/docs/14/functions-array.html array_append array_cat array_remove array_replace and more
Oh, man thank you very much!
Обсуждают сегодня