Re: Adding New Column with default value.

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Adding New Column with default value.
Date: 2025-04-28 18:34:45
Message-ID: CAKFQuwagzKP60k=Cya0d38+wxrgOyVvjPPx16SBdOtNimjGSHg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Apr 28, 2025 at 10:25 AM Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ed Sabol 2025-04-29 01:13:22 Re: Adding New Column with default value.
Previous Message Ron Johnson 2025-04-28 17:46:15 Re: Adding New Column with default value.