Re: Adding SHOW CREATE TABLE

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Nathaniel Sabanski <sabanski(dot)n(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Adding SHOW CREATE TABLE
Date: 2023-05-12 14:40:38
Message-ID: ZF5P5sg4urdQfM0k@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Greetings,

Please don't top-post on these lists.

* Nathaniel Sabanski (sabanski(dot)n(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thorsten Glaser 2023-05-12 15:35:45 Re: Adding SHOW CREATE TABLE
Previous Message Nathaniel Sabanski 2023-05-12 14:34:44 Re: Adding SHOW CREATE TABLE

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2023-05-12 15:18:42 Re: psql tests hangs
Previous Message Peter Eisentraut 2023-05-12 14:35:34 Re: createuser --memeber and PG 16