rename a column postgres code example
Example 1: psql filed name alter
ALTER TABLE table_name
RENAME column_name TO new_column_name;
Example 2: how to update column name in psql
ALTER TABLE order_details
DROP COLUMN notes;
ALTER TABLE table_name
RENAME column_name TO new_column_name;
ALTER TABLE order_details
DROP COLUMN notes;