Re: Adding SHOW CREATE TABLE

2023-05-12 Thread Nathaniel Sabanski
> Perhaps a bit more discussion about what exactly the use-case is would > be helpful- what would you use this feature for? App writers: To facilitate table creation and simplify schema verification, without relying on a GUI tool or ORM (or system calls out to pg_dump). Tool writers: Would drasti

Re: Adding SHOW CREATE TABLE

2023-05-12 Thread Nathaniel Sabanski
On Fri, 12 May 2023 at 09:12, David G. Johnston wrote: > > > On Fri, May 12, 2023, 08:35 Thorsten Glaser wrote: > >> On Fri, 12 May 2023, Nathaniel Sabanski wrote: >> >> >I believe most users would anticipate a CREATE TABLE statement that >> aligns >>

Re: Adding SHOW CREATE TABLE

2023-05-12 Thread Nathaniel Sabanski
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. On Fri, 12 May 2023 at 06:47, Stephen Frost wrote: > Greetings, > > * Nathaniel Sabanski (sabansk...@gmail.c

Adding SHOW CREATE TABLE

2023-05-12 Thread Nathaniel Sabanski
HN had a thread regarding the challenges faced by new users during the adoption of Postgres in 2023. One particular issue that garnered significant votes was the lack of a "SHOW CREATE TABLE" command, and seems like it would be an easy one to implement: https://news.ycombinator.com/item?id=3590899