How to Rename a Column in PostgreSQL
Last updated July 24, 2026 · By the SaturnSQL team
Use ALTER TABLE ... RENAME COLUMN old TO new. It is a metadata-only change, and Postgres rewrites references in views and constraints automatically.
ALTER TABLE orders RENAME COLUMN amount TO order_amount;Unlike most databases, dependent Postgres views keep working after the rename because they reference the column internally by number, not name. Application code is what breaks; grep it before renaming.
Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free