public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Lakshmi N <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Show VIRTUAL keyword for virtual generated columns in pg_dump and psql
Date: Mon, 13 Apr 2026 05:27:06 -0700
Message-ID: <CAKFQuwan3J1WdqtiXr4u9Lmj+5Z7r+hYOKfy_A1g23_8f90LWw@mail.gmail.com> (raw)
In-Reply-To: <CA+3i_M8Rj0yEA5rRbWjobNbcZsB0MExfZbKV-mkWwFeyRvanCw@mail.gmail.com>
References: <CA+3i_M8Rj0yEA5rRbWjobNbcZsB0MExfZbKV-mkWwFeyRvanCw@mail.gmail.com>
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.
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Show VIRTUAL keyword for virtual generated columns in pg_dump and psql
In-Reply-To: <CAKFQuwan3J1WdqtiXr4u9Lmj+5Z7r+hYOKfy_A1g23_8f90LWw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox