alter table postgresql
PostgreSQL ADD COLUMN Statement to Add One or Multiple Columns To a Table
Latest posts by dbForge Team (see all)
- How to Create Login, User, and Grant Permissions in SQL Server - November 25, 2021
- How to Restore a MySQL Database with Command Line or Restore Tools - November 22, 2021
- Don’t Miss the Latest Maintenance Update of SQL Complete 6.9 - November 15, 2021
If you have been looking for a tutorial on the ALTER TABLE command in Postgres, your search ends here. This statement changes the definition of an existing table. In this article, we will be focusing on the ALTER TABLE ADD COLUMN syntax, which narrows down the functionality of ALTER TABLE to a single action: adding a column. We will walk you through different ways of adding a column using the command line, and also, a convenient GUI tool for PostgreSQL.