> > 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.gd24...@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_rwwqfv8wp68...@mail.gmail.com Clearly, there is customer demand for something like this, and has been for a long time.