Re: Adding New Column with default value.
| От | Ron Johnson |
|---|---|
| Тема | Re: Adding New Column with default value. |
| Дата | |
| Msg-id | CANzqJaDDCNoLq1E5ZvebwgehN=kFmfsH0f0hmi7tBjwGJR2GTg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Adding New Column with default value. (Gambhir Singh <gambhir.singh05@gmail.com>) |
| Список | pgsql-admin |
On Mon, Apr 28, 2025 at 1:25 PM Gambhir Singh <gambhir.singh05@gmail.com> wrote:
I got request from app Team to add new column to a table with following specifications1. With Not Null Constraint2. With Default value 0Row Count - 50 BillionPlease help me to understanda. DDL statement (alter table add column) will be followed by the DML statement (Update)....Am I correct ?
Do you want existing rows to have a value of 0, or just new ones?
b. What would be size of the Table (I assuming it will be doubled)
It will double if the table currently only has one scalar column.
c. What is the best approach for this kind of activity.
The ALTER TABLE documentation is pretty long, but searching it for "update", and reading carefully gives pointers.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
В списке pgsql-admin по дате отправления: