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

>
>
>
> So it results in something like
> select pg_get_table_ddl('sch1.x'::regclass, schema_qualified => false)
> CREATE TABLE x(...)
> ALTER TABLE x...
> CREATE CONSTRAINT yyy on x ...
> CREATE INDEX idx on x...
> CREATE TRIGGER ... --This one will use your function
>
>
In looking at this a bit more closer, over several days, in order to do
this, it would require a patch to pg_get_triggerdef_worker. At the same
time, I am not even sure that relying on the input of pg_get_table_ddl to
cascade parameters down the chain to other pg_get_*_ddl functions is what
is intended. My thought would be that if the table_ddl is to provide this
information, it would strip out the schema itself.

--
Best,
Phil Alger