"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Mon, Apr 22, 2024 at 12:42 PM Celia McInnis <celia.mcinnis@xxxxxxxxx> > 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. I think what you'd need to do is drop the existing column and then add a generated column. regards, tom lane
