grafana postgres update

grafanadb=> select table_schema, table_name, column_name from information_schema.columns where column_name like '%email%';
 table_schema | table_name |  column_name
--------------+------------+----------------
 public       | temp_user  | email_sent
 public       | temp_user  | email_sent_on
 public       | user       | email_verified
 public       | org        | billing_email
 public       | user       | email
 public       | team       | email
 public       | temp_user  | email
(7 rows)

grafanadb=> select id, login, email, name, company from public.user where email like '%n.family%';
 id |          login          |          email          |           name            | company
----+-------------------------+-------------------------+---------------------------+---------
 85 | n.family@domain.com | n.family@domain.com | Имя Фамилиев Отчествович |
(1 row)


grafanadb=> update public.user set email='n.family@domain.ru' where email like '%n.family%';
UPDATE 1
Запись опубликована в рубрике overminds с метками , . Добавьте в закладки постоянную ссылку.