How to add a new column in PostgreSQL?

@hal.littel 

To add a new column to a table in PostgreSQL, you can use the ALTER TABLE statement and the ADD COLUMN clause. Here's the basic syntax:

1
2

ALTER TABLE table_name
ADD COLUMN column_name data_type;

For example, to add a new column called email to a table called customers, you can use the following statement:

1
2

ALTER TABLE customers
ADD COLUMN email VARCHAR(255);

This will add a new column called email to the customers table, with a data type of VARCHAR(255). You can replace VARCHAR(255) with any other data type that is supported by PostgreSQL.

You can also specify additional options when adding a new column, such as a default value or a constraint. For example, to add a new column called age to a table called employees, with a default value of 18, you can use the following statement:

1
2

ALTER TABLE employees
ADD COLUMN age INT DEFAULT 18;

This will add a new column called age to the employees table, with a data type of INT and a default value of 18.

I hope this helps! Let me know if you have any questions.

@hal.littel 

To add a new column in PostgreSQL, you can use the ALTER TABLE statement with the ADD COLUMN clause. Here is the syntax:

1
2

ALTER TABLE table_name 
ADD COLUMN column_name data_type;

For example, let's say you have a table named "employees" and you want to add a new column called "salary" of type numeric:

1
2

ALTER TABLE employees
ADD COLUMN salary numeric;

You can also specify additional constraints such as default values, NOT NULL, and foreign key constraints if needed. Here are some examples:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

-- Add a column with a default value
ALTER TABLE employees
ADD COLUMN hire_date date DEFAULT current_date;

-- Add a column with a NOT NULL constraint
ALTER TABLE employees
ADD COLUMN email varchar(255) NOT NULL;

-- Add a column with a foreign key constraint
ALTER TABLE employees
ADD COLUMN department_id integer REFERENCES departments(department_id);

You can include multiple ADD COLUMN statements within a single ALTER TABLE statement if you want to add multiple columns at once.