Skip to content

Update email address of a profile

Charles de Beauchesne edited this page Nov 2, 2020 · 2 revisions

⚠️ be sure of what you are doing!

# Connect
source /opt/c2corg-docker/server-list.env
cd /opt/c2corg-docker/composition/production/postgresql-main/

# Check old value
docker-compose exec --user postgres postgresql psql -tA -d c2corg -P pager=off -c "SELECT email FROM users.user WHERE id=<N>"

# Update
docker-compose exec --user postgres postgresql psql -tA -d c2corg -P pager=off -c "UPDATE users.user SET email = 'new@mail.com' WHERE id=<N>"