Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding SHOW CREATE TABLE - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: Adding SHOW CREATE TABLE
Date
Msg-id CADkLM=cayR+3vSGZAKS4dUsQE+ttpi0TT=oR3gVTmQ8gDnLKKA@mail.gmail.com
Whole thread Raw
In response to Re: Adding SHOW CREATE TABLE  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Tree view

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/> and <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.

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Add operator for dividing interval by an interval
Next
From: Laurenz Albe
Date:
Subject: Re: Adding SHOW CREATE TABLE