From: Stephen Frost <sfrost@snowman.net>
To: Nathaniel Sabanski <sabanski.n@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Adding SHOW CREATE TABLE
Date: Fri, 12 May 2023 10:40:38 -0400
Message-ID: <ZF5P5sg4urdQfM0k@tamriel.snowman.net> (raw)
In-Reply-To: <CAFEN2wzmO-VqOjOU3EyWzBCckDY3-_nv5sXQJPunteNHq9r11A@mail.gmail.com>
References: <CAFEN2wxsDSSuOvrU03CE33ZphVLqtyh9viPp6huODCDx2UQkYA@mail.gmail.com>
<ZF5Da5Ge1+RpiviX@tamriel.snowman.net>
<CAFEN2wzmO-VqOjOU3EyWzBCckDY3-_nv5sXQJPunteNHq9r11A@mail.gmail.com>
Greetings,
Please don't top-post on these lists.
* Nathaniel Sabanski (sabanski.n@gmail.com) wrote:
> I believe most users would anticipate a CREATE TABLE statement that aligns
> with the currently installed version- this is the practical solution for
> the vast majority.
Perhaps a bit more discussion about what exactly the use-case is would
be helpful- what would you use this feature for?
> In situations where a CREATE TABLE statement compatible with an older
> version of Postgres is required, users can opt for an additional step of
> using tools like pg_dump or an older version of Postgres itself. This
> allows them to ensure compatibility without compromising the practicality
> of the process.
The issue is really both older and newer versions, not just older ones
and not just newer ones.
To the extent you're interested in this, I pointed out where you could
go look at the existing code as well as an idea for how to move this
forward.
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 832B) download
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: sfrost@snowman.net, sabanski.n@gmail.com
Subject: Re: Adding SHOW CREATE TABLE
In-Reply-To: <ZF5P5sg4urdQfM0k@tamriel.snowman.net>
References: <CAFEN2wxsDSSuOvrU03CE33ZphVLqtyh9viPp6huODCDx2UQkYA@mail.gmail.com> <ZF5Da5Ge1+RpiviX@tamriel.snowman.net> <CAFEN2wzmO-VqOjOU3EyWzBCckDY3-_nv5sXQJPunteNHq9r11A@mail.gmail.com> <ZF5P5sg4urdQfM0k@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox