ITMan Documents

This Weblog Just Created For Document Sysadmin Challenges

Modify A Column Type

---On Postgres CLI---
ALTER TABLE <Table Name> ALTER COLUMN <Column Name> TYPE <New Type>;

---Example---
ALTER TABLE tokens ALTER COLUMN token TYPE text;
Last updated on 26 Oct 2020
Published on 23 Nov 2018