DB Pilot icon DB Pilot

How to Rename a Column in PostgreSQL

This example renames the column my_column to my_renamed_column:

ALTER TABLE my_table
RENAME COLUMN my_column TO my_renamed_column;
Previous
How to Drop a Column in PostgreSQL
Next
How to Query JSON in PostgreSQL

Get started with DB Pilot

DB Pilot is a Database GUI client and SQL editor for PostgreSQL, MySQL, SQLite, DuckDB & more.

Download Learn more