{"id":237746,"date":"2024-05-06T09:32:19","date_gmt":"2024-05-06T09:32:19","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=237746"},"modified":"2024-05-06T09:32:19","modified_gmt":"2024-05-06T09:32:19","slug":"how-to-add-a-column-in-postgresql-with-a-default-value","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-add-a-column-in-postgresql-with-a-default-value\/","title":{"rendered":"How to add a column in PostgreSQL with a default value?"},"content":{"rendered":"

Adding a column in PostgreSQL with a default value is a common operation when working with databases. This can be useful when you want to ensure that newly added records have a specific value in the column. To add a column with a default value in PostgreSQL, follow the steps below:<\/p>\n

1. **ALTER TABLE table_name ADD COLUMN column_name data_type DEFAULT default_value;**<\/p>\n

Replace ‘table_name’ with the name of the table where you want to add the column, ‘column_name’ with the name of the new column, ‘data_type’ with the data type of the column, and ‘default_value’ with the default value you want to set for the column.<\/p>\n

For example, if you want to add a column named ‘status’ with a default value of ‘active’ to a table called ‘users’, you would use the following SQL query:<\/p>\n

“`sql
\nALTER TABLE users ADD COLUMN status VARCHAR(10) DEFAULT ‘active’;
\n“`<\/p>\n

This query adds a new column named ‘status’ with a data type of VARCHAR(10) and sets the default value to ‘active’.<\/p>\n

2. Once you run the ALTER TABLE query, the new column will be added to the table with the specified default value. From this point forward, any new records added to the table will automatically have the default value in the new column.<\/p>\n

By following this simple process, you can easily add a column in PostgreSQL with a default value to your database tables.<\/p>\n

\n
\n

Table of Contents<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n