Home > mailing lists

Re: Adding New Column with default value. - Mailing list pgsql-admin

From	David G. Johnston
Subject	Re: Adding New Column with default value.
Date	April 28 21:34:45
Msg-id	CAKFQuwagzKP60k=Cya0d38+wxrgOyVvjPPx16SBdOtNimjGSHg@mail.gmail.com Whole thread Raw
In response to	Adding New Column with default value. (Gambhir Singh <gambhir.singh05@gmail.com>)
List	pgsql-admin

On Mon, Apr 28, 2025 at 10:25 AM Gambhir Singh <gambhir.singh05@gmail.com> wrote:

a. DDL statement (alter table add column) will be followed by the DML statement (Update)....Am I correct ?

No. An alter command will either rewrite the table or it will not. It will never execute DML.

David J.

From: Ron Johnson
Date: 28 April, 20:46:15
Subject: Re: Adding New Column with default value.