Answers for "how to edit data in postgresql"

postgresql change value in column

UPDATE table_name
SET column1 = value1,
    column2 = value2,
    ...
WHERE column3 = value3;

Posted by: Guest on November-02-2021

update database collation in postgresql

update pg_database set datcollate='POSIX.UTF-8', datctype='POSIX.UTF-8' where datname='databasename';

Posted by: Guest on June-18-2020

Code answers related to "how to edit data in postgresql"