Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement

Marcos Pegoraro <marcos@f10.com.br>

From: Marcos Pegoraro <marcos@f10.com.br>

To: Jim Jones <jim.jones@uni-muenster.de>

Cc: Philip Alger <paalger0@gmail.com>, Andrew Dunstan <andrew@dunslane.net>, Cary Huang <cary.huang@highgo.ca>, jian he <jian.universality@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2025-10-18T17:01:05Z

Lists: pgsql-hackers

Em sáb., 18 de out. de 2025 às 12:19, Jim Jones <jim.jones@uni-muenster.de>
escreveu:

> Other than that, the patch LGTM. If the other reviewers have no
> objections, I'll mark it as ready for committer.
>

Before committing, thinking of all these features, triggers, constraints,
tables, etc, to be all of them really useful, wouldn't it be better to have
an option to drop them first or create if not exists when available ?

pg_get_trigger_ddl(oid, pretty, drop_first) ?

regards
Marcos