PostgreSQL Update Table: Change the value of a column with user defined text

Last update on February 26 2020 08:09:40 (UTC/GMT +8 hours)

1. Write a SQL statement to change the email column of the employees table with 'not available' for all employees.

Sample table : employees

Sample Solution:

Code:

UPDATE employees SET email='not available';

Output:

See the result. Only two rows have been displayed.

postgres=# SELECT * FROM employees LIMIT 2;
 employee_id | first_name | last_name |     email     | phone_number | hire_date  | job_id  |  salary  | commission_pct | manager_id | department_id
-------------+------------+-----------+---------------+--------------+------------+---------+----------+----------------+------------+---------------
         100 | Steven     | King      | not available | 515.123.4567 | 1987-06-17 | AD_PRES | 24000.00 |           0.00 |          0 |            90
         101 | Neena      | Kochhar   | not available | 515.123.4568 | 1987-06-18 | AD_VP   | 17000.00 |           0.00 |        100 |            90

-->

Have another way to solve this solution? Contribute your code (and comments) through Disqus.