Skip to content

add a column with a default value to an existing table

add column in existing table

For inserting a new field in an existing table, use the ALTER statement. The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. To add a new column to an existing table, use the  ADD COLUMN statement. Syntax Specify the name of the table that you want to add a new column to after the ALTER TABLE keyword and then specify the name of the new column with its data type and… Read More »Adding one or more Column in Existing Table in PostgreSQL

Adding one or more Column in Existing Table in PostgreSQL