| From: | Corey Huinker <corey(dot)huinker(at)gmail(dot)com> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Adding SHOW CREATE TABLE |
| Date: | 2023-05-19 20:57:44 |
| Message-ID: | CADkLM=cayR+3vSGZAKS4dUsQE+ttpi0TT=oR3gVTmQ8gDnLKKA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
>
> I think the ONLY place we should have this is in server side functions.
> More than ten years ago I did some work in this area (see below), but it's
> one of those things that have been on my ever growing personal TODO list
>
> See <https://bitbucket.org/adunstan/retailddl/src/master/>
> <https://bitbucket.org/adunstan/retailddl/src/master/> and
> <https://www.youtube.com/watch?v=fBarFKOL3SI>
> <https://www.youtube.com/watch?v=fBarFKOL3SI>
>
>
>
> Some additional backstory, as this has come up before...
A direction discussion of a previous SHOW CREATE effort:
https://www.postgresql.org/message-id/20190705163203.GD24679@fetter.org
Other databases' implementations of SHOW CREATE came up in this discussion
as well:
https://www.postgresql.org/message-id/CADkLM=fxfsrHASKk_bY_A4uomJ1Te5MfGgD_rwwQfV8wP68ewg@mail.gmail.com
Clearly, there is customer demand for something like this, and has been for
a long time.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2023-05-19 21:06:00 | Re: Adding SHOW CREATE TABLE |
| Previous Message | Elterman, Michael | 2023-05-19 20:55:40 | Re: Trying to understand a failed upgrade in AWS RDS |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2023-05-19 21:06:00 | Re: Adding SHOW CREATE TABLE |
| Previous Message | Andres Freund | 2023-05-19 20:01:27 | Re: Add operator for dividing interval by an interval |