On Mon, 2023-02-27 at 03:52 +, Neethu P wrote:
> Is it possible to access the pg_ddl_command using C function? In the shared
> links,
> I couldn't find one. Can you please share an example for the same?
No. You could hire a professional.
Yours,
Laurenz Albe
hu P ; n.kobza...@aeronavigator.ru
; 'pgsql-general'
Subject: Re: Event Triggers unable to capture the DDL script executed
On Thu, 2023-02-23 at 04:10 +, Neethu P wrote:
> Actually, current_query() may not help us in our case, as we won't be able
> to capture the ddl statement complete
; 'pgsql-general'
Subject: Re: Event Triggers unable to capture the DDL script executed
On Thu, 2023-02-23 at 04:10 +, 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
On Thu, 2023-02-23 at 04:10 +, 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
Regards,
Neethu
From: n.kobza...@aeronavigator.ru
Sent: Wednesday, February 22, 2023 3:33 PM
To: 'Laurenz Albe' ; 'Neethu P'
; 'pgsql-general'
Subject: RE: Event Triggers unable to capture the DDL script executed
>>-Исходное сообщение-
>
>>-Исходное сообщение-
>>От: Laurenz Albe
>>Отправлено: 22 февраля 2023 г. 12:52
>>Кому: Neethu P ; pgsql-general
>>
>>Тема: Re: Event Triggers unable to capture the DDL script executed
>>On Wed, 2023-02-22 at 07:57 +, Neethu P wrote:
On Wed, 2023-02-22 at 07:57 +, Neethu P wrote:
> We are using event triggers to capture the DDL changes in a postgres database.
> However, we are unable to get the column information & the actual DDL script
> executed, while a table is altered.
> Also, in the postgres documentation for
