On Thu, 2023-02-23 at 04:10 +0000, Neethu P wrote:
> Actually, current_query() may not help us in our case, as we won't be able
> to capture the ddl statement completely in case if it's in multiple lines.
Multiple lines should not be a problem. The problems I see are
- you won't catch DDL statements issued in a function with that, since you
only see the top-level statement
- if you have the DDL statement as string, you need to parse it, which is
non-trivial
> Can you please help me with the event trigger in C? & also how can we
> integrate it with our current postgresql DB?
In an e-mail, I cannot do much beyond pointing you to the documentation:
https://www.postgresql.org/docs/current/event-trigger-interface.html There is also a simple example:
https://www.postgresql.org/docs/current/event-trigger-example.html Getting used to reading and writing PostgreSQL server code takes a while.
Yours,
Laurenz Albe
