Re: Adding SHOW CREATE TABLE

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>

To: Kirk Wolak <wolakk@gmail.com>

Cc: Jelte Fennema <postgres@jeltef.nl>, Pavel Stehule <pavel.stehule@gmail.com>, pgsql-hackers@lists.postgresql.org

Date: 2023-06-01T20:46:07Z

Lists: pgsql-hackers, pgsql-general

On 2023-06-01 Th 16:39, Kirk Wolak wrote:
> On Thu, Jun 1, 2023 at 3:13 PM Andrew Dunstan <andrew@dunslane.net> wrote:
>
>     On 2023-06-01 Th 12:57, Kirk Wolak wrote:
>
>>     PS: It dawned on me that if pg_dump had used server side code to
>>     generate its DDL, its complexity would drop.
>
>     Maybe, that remains to be seen. pg_dump needs to produce SQL that
>     is suitable for the target database, not the source database.
>
>
> First, pg_dump has some special needs in addressing how it creates 
> tables, to be able to load the data BEFORE indexing, and constraining 
> (lest you have to struggle with dependencies of FKs, etc etc)...
>
> But version checking is interesting... Because I found no way to tell 
> pg_dump what DB to target.
>

The target version is implicitly the version it's built from.


cheers


andrew


--
Andrew Dunstan
EDB:https://www.enterprisedb.com