Re: SHOW CREATE - Mailing list pgsql-hackers

From Michael Glaesemann
Subject Re: SHOW CREATE
Date
Msg-id AD031B6B-6CF0-4302-847B-633058AB66B5@seespotcode.net
Whole thread Raw
In response to Re: SHOW CREATE  (Corey Huinker <corey.huinker@gmail.com>)
Responses Re: SHOW CREATE
List pgsql-hackers

> On 2019–07–05, at 12:14, Corey Huinker <corey.huinker@gmail.com> wrote:
>
> In doing that work, it became clear that the command was serving two masters:
> 1. A desire to see the underlying nuts and bolts of a given database object.
> 2. A desire to essentially make the schema portion of pg_dump a server side command.
>
> To that end, I see splitting this into two commands, SHOW CREATE and SHOW DUMP.

I like the idea of having these features available via SQL as opposed to separate tools. Is it necessary to have
specificcommands for them? It seems they would potentially more useful as functions, where they'd be available for all
ofthe programmatic features of the rest of SQL. 

Michael Glaesemann
grzm seespotcode net






pgsql-hackers by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Patch to document base64 encoding
Next
From: Tomas Vondra
Date:
Subject: Re: Avoiding hash join batch explosions with extreme skew and weirdstats