Answers for "update columns psql"

postgresql change value in column

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

Posted by: Guest on November-02-2021

how to update column name in psql

ALTER TABLE table_name
  RENAME COLUMN old_name TO new_name;

Posted by: Guest on March-12-2020

Code answers related to "update columns psql"