PostgreSQL – Renaming a Column

Below is the syntax to rename a column in Postgres where tablename is the name of the table and columnname is the existing column name and newcolumnname is the new column name.

ALTER TABLE tablename RENAME COLUMN columnname TO newcolumnname;