Hi, On Mon, Apr 13, 2026 at 5:27 AM David G. Johnston < [email protected]> wrote:
> 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. > Thank you for the feedback! Updated the patch for psql \d only. Regards, Lakshmi
0001-Fix-psql-d-to-show-VIRTUAL-keyword-for-generated-col.patch
Description: Binary data
