pgsql: Add pg_get_database_ddl() function
| От | Andrew Dunstan |
|---|---|
| Тема | pgsql: Add pg_get_database_ddl() function |
| Дата | |
| Msg-id | E1w9OzU-0035rB-1P@gemulon.postgresql.org обсуждение исходный текст |
| Список | pgsql-committers |
Add pg_get_database_ddl() function Add a new SQL-callable function that returns the DDL statements needed to recreate a database. It takes a regdatabase argument and an optional VARIADIC text argument for options that are specified as alternating name/value pairs. The following options are supported: pretty (boolean) for formatted output, owner (boolean) to include OWNER and tablespace (boolean) to include TABLESPACE. The return is one or multiple rows where the first row is a CREATE DATABASE statement and subsequent rows are ALTER DATABASE statements to set some database properties. The caller must have CONNECT privilege on the target database. Author: Akshay Joshi <akshay.joshi@enterprisedb.com> Co-authored-by: Andrew Dunstan <andrew@dunslane.net> Co-authored-by: Euler Taveira <euler@eulerto.com> Reviewed-by: Japin Li <japinli@hotmail.com> Reviewed-by: Chao Li <li.evan.chao@gmail.com> Reviewed-by: Álvaro Herrera <alvherre@kurilemu.de> Reviewed-by: Quan Zongliang <quanzongliang@yeah.net> Discussion: https://postgr.es/m/CANxoLDc6FHBYJvcgOnZyS+jF0NUo3Lq_83-rttBuJgs9id_UDg@mail.gmail.com Discussion: https://postgr.es/m/e247c261-e3fb-4810-81e0-a65893170e94@dunslane.net Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/a4f774cf1c7e5c6cf2f3393f611e1df16cdb5a5a Modified Files -------------- doc/src/sgml/func/func-info.sgml | 23 ++ src/backend/utils/adt/ddlutils.c | 330 +++++++++++++++++++++++++++++ src/include/catalog/pg_proc.dat | 8 + src/test/regress/expected/database_ddl.out | 88 ++++++++ src/test/regress/parallel_schedule | 2 +- src/test/regress/sql/database_ddl.sql | 66 ++++++ 6 files changed, 516 insertions(+), 1 deletion(-)
В списке pgsql-committers по дате отправления: