Postgres Alter Column Type Example

How to change a table column type in Postgres

ALTER TABLE
  "users"
ALTER COLUMN
  "first_name" TYPE varchar(255)

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 editing by right-clicking on a table in the sidebar and clicking 'View Structure'.

Download Beekeeper Studio