From: | Thomas Kellerer <shammat(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Adding SHOW CREATE TABLE |
Date: | 2023-05-12 15:54:00 |
Message-ID: | 5b7f8267-b6b9-b678-94c6-82d113936ea3@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Nathaniel Sabanski schrieb am 12.05.2023 um 13:29:
> 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=35908991
>
> Considering the popularity of this request and its potential ease of
> implementation, I wanted to bring it to your attention, as it would
> likely enhance the user experience and alleviate some of the
> difficulties encountered by newcomers.
While it would be nice to have something like that, I don't think
it isn't really necessary. Pretty much every (GUI) SQL client provides
a way to see the DDL for objects in the database.
For psql fans \d typically is enough, and they would probably not mind
running pg_dump to get the full DDL.
I would think that especially newcomers start with a GUI client
that can do this.
If you check the source of any of the popular SQL clients that generates
the DDL for a table, then you will also quickly realize that this isn't
a trivial thing to do.
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | FOUTE K. Jaurès | 2023-05-12 16:03:28 | PG_Cron - Error Message Connection failed |
Previous Message | Marc Millas | 2023-05-12 15:41:37 | Re: Death postgres |
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2023-05-12 16:12:14 | Re: Adding SHOW CREATE TABLE |
Previous Message | Tom Lane | 2023-05-12 15:50:53 | Re: psql tests hangs |