pg.ddx.io pgsql-general@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stephen Frost <sfrost@snowman.net>
Cc: Nathaniel Sabanski <sabanski.n@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Adding SHOW CREATE TABLE
Date: Fri, 12 May 2023 16:27:51 -0400
Message-ID: <1565715.1683923271@sss.pgh.pa.us> (raw)
In-Reply-To: <ZF6eIysBeQrXpz7r@tamriel.snowman.net>
References: <CAFEN2wxsDSSuOvrU03CE33ZphVLqtyh9viPp6huODCDx2UQkYA@mail.gmail.com>
<ZF5Da5Ge1+RpiviX@tamriel.snowman.net>
<CAFEN2wzmO-VqOjOU3EyWzBCckDY3-_nv5sXQJPunteNHq9r11A@mail.gmail.com>
<7a5d6750-84fa-59b0-33c1-7a5d26b9bc74@evolvis.org>
<CAKFQuwa2cYznMsZRdfDXqDD0T5F+cRruZxfu_W9BtDh+A5RYHg@mail.gmail.com>
<CAFEN2wwzcNot7OuV-4CLo5qf8UNZyc7pkEitJiYrj6VRTL4vmQ@mail.gmail.com>
<CAFEN2wxg0Vtj1gvk6Ms0L2CAutbycyxHZPiZSpW7eLsBc6VGnA@mail.gmail.com>
<ZF6eIysBeQrXpz7r@tamriel.snowman.net>
Stephen Frost <sfrost@snowman.net> writes:
> Again, would be great to see someone actually work on this. There's
> already a good chunk of code in core in pg_dump and in the postgres_fdw
> for doing exactly this and it'd be great to consolidate that and at the
> same time expose it via SQL.
Note that this is hardly new ground: we've heard more-or-less the same
proposal many times before. I think the reason it's gone nowhere is
that most of the existing infrastructure is either in pg_dump or designed
to support pg_dump, and pg_dump is *extremely* opinionated about what
it wants and how it wants the data sliced up, for very good reasons.
Reconciling those requirements with a typical user's "just give me a
reconstructed CREATE TABLE command" request seems fairly difficult.
Also, since pg_dump will still need to support old servers, it's hard
to believe we'd accept any proposal to move that functionality into
the server side, which in turn means that it's not going to be an easy
SQL command.
These issues probably could be surmounted with enough hard work, but
please understand that just coming along with a request is not going
to cause it to happen. People have already done that. (Searching
the mailing list archives might be edifying.)
regards, tom lane
view thread (46+ messages) latest in thread
Message-ID: <1565715.1683923271@sss.pgh.pa.us> Permalink: ../1565715.1683923271@sss.pgh.pa.us/ Also on: postgresql.org/message-id/1565715.1683923271@sss.pgh.pa.us ·
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 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: tgl@sss.pgh.pa.us, sfrost@snowman.net, sabanski.n@gmail.com Subject: Re: Adding SHOW CREATE TABLE In-Reply-To: <1565715.1683923271@sss.pgh.pa.us> References: <CAFEN2wxsDSSuOvrU03CE33ZphVLqtyh9viPp6huODCDx2UQkYA@mail.gmail.com> <ZF5Da5Ge1+RpiviX@tamriel.snowman.net> <CAFEN2wzmO-VqOjOU3EyWzBCckDY3-_nv5sXQJPunteNHq9r11A@mail.gmail.com> <7a5d6750-84fa-59b0-33c1-7a5d26b9bc74@evolvis.org> <CAKFQuwa2cYznMsZRdfDXqDD0T5F+cRruZxfu_W9BtDh+A5RYHg@mail.gmail.com> <CAFEN2wwzcNot7OuV-4CLo5qf8UNZyc7pkEitJiYrj6VRTL4vmQ@mail.gmail.com> <CAFEN2wxg0Vtj1gvk6Ms0L2CAutbycyxHZPiZSpW7eLsBc6VGnA@mail.gmail.com> <ZF6eIysBeQrXpz7r@tamriel.snowman.net> <1565715.1683923271@sss.pgh.pa.us> * 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