On Monday, April 13, 2026, Lakshmi N <[email protected]> wrote: > > pg_dump and psql's \d currently display stored and virtual generated > columns asymmetrically: >
> > s_total integer GENERATED ALWAYS AS ((a + b)) STORED > v_total integer GENERATED ALWAYS AS ((a + b)) > > Since VIRTUAL is default most likely this was omitted but with this > puts the burden on the reader to identify whether it is STORED or > VIRTUAL since both kinds coexist in v19. > The output follows existing conventions of not printing extraneous text. Additionally, storage itself is non-standard so the absence of a modifier is producing standard-compliant output. I would -1 changing pg_dump on this basis. I’d be inclined to go with the symmetry/readability argument for psql \d though. David J.
