Reference: Alter Table Statement

Alter table allows modifying the definition of a table. See PostgreSQL: ALTER TABLE for the PostgreSQL documentation.

Column statememts

RENAME COLUMN

ALTER TABLE IF EXISTS movies RENAME COLUMN runlength TO duration;

Rename column of table with table_name and current_column_name to the new_column_name. If exists checks if the table exists and only tries to rename in the case of existence.