PostgreSQL Tutorials: How To Rename A Column

You can rename a column in a PostgreSQL table using the ‘RENAME COLUMN’ command as follows:

ALTER TABLE tablename
RENAME columnname TO preferredcolumnname;