alter table postgresql
PostgreSQL ADD COLUMN Statement to Add One or Multiple Columns To a Table
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.