Re: altering a column to to make it generated

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Celia McInnis <celia(dot)mcinnis(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: altering a column to to make it generated
Date: 2024-04-22 19:45:46
Message-ID: CAKFQuwb5i7nW+QcYfpCb2=SnXyURsGXd3_YwEBw61HuB4muv2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Apr 22, 2024 at 12:42 PM Celia McInnis <celia(dot)mcinnis(at)gmail(dot)com>
wrote:

> Can I alter a table column to now make it generated? I tried this
> unsuccessfully:
>

I looked at all of the "alter table ... alter column" commands listed here:

https://www.postgresql.org/docs/current/sql-altertable.html

And none seem to involve the generated expression column. So the answer is
no.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-04-22 19:51:54 Re: CLUSTER vs. VACUUM FULL
Previous Message Celia McInnis 2024-04-22 19:42:09 altering a column to to make it generated