Re: Feature request: pg_get_tabledef(text)
| От | Ron Johnson |
|---|---|
| Тема | Re: Feature request: pg_get_tabledef(text) |
| Дата | |
| Msg-id | CANzqJaCpuhhOEfdtRR=ZZrpMDAZcXYmc3c6BeQw_CMCJXfm+Rw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Feature request: pg_get_tabledef(text) (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Список | pgsql-general |
On Wed, Nov 22, 2023 at 11:09 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Wed, 2023-11-22 at 16:41 +0100, Hans Schou wrote:
> Similar to pg_get_viewdef() and pg_get_functiondef() it would be useful with a pg_get_tabledef() to get a full description of how a table is defined.
This has been requested before:
https://www.postgresql.org/message-id/flat/CAFEN2wxsDSSuOvrU03CE33ZphVLqtyh9viPp6huODCDx2UQkYA%40mail.gmail.com
One of the problems is what should be included.
Indexes? Policies? Constraints?
Another problem is that while a function or view definition is a single
SQL statement, a table definition could consist of more than a single
statement, depending on the answer to the previous question.
No unsurmountable questions, but someone would have to come up with a
clear design and implement it.
Because you can already get all the other DDL relevant to creating a table (like indices, primary and foreign keys, grants), ISTM that just a plain CREATE TABLE with column DEFAULT clauses is what pg_get_tabledef() should create.
A comprehensive "recreate everything related to a table" function should be left as an exercise for the DBA.
В списке pgsql-general по дате отправления: