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 с метками
grafana,
postgres. Добавьте в закладки
постоянную ссылку.