Updating a Record in a Postgres Database

Sunday, October 03, 2021

This is how to update a record in a postgres table using PSQL

UPDATE {table_name} SET column_name='value' WHERE {column}='value';

UPDATE public.user SET email='chi@gmail.com' WHERE id='1d5e1855-804c-4a1e-9266-c1680fb5c0ce';
Powered By Swish