Amazon Redshift Rename Column Example

How to rename a table column in Amazon Redshift

ALTER TABLE
  "users" RENAME COLUMN "last_name" TO "family_name"

Using Beekeeper Studio?

Beekeeper Studio is a free and open source database manager for Windows, Mac, and Linux.

This feature is baked right in, so there's no need to manually type SQL every time. Access column renaming by right-clicking on a table in the sidebar and clicking 'View Structure'.

Download Beekeeper Studio