Schema evolutionPostgreSQL
ALTER TABLE
Add columns, constraints, or indexes to existing tables.
Command
ALTER TABLE ADD COLUMN TEXT;
Example usage
Evolve schemas safely with new columns or constraints.
ALTER TABLE <table> ADD COLUMN <column> TEXT;ALTER TABLE <table> ADD CONSTRAINT <name> UNIQUE (<column>);Related tags
Schema evolutiondatabasesqlpsql