Re: How to watch for schema changes - Mailing list pgsql-general

From David G. Johnston
Subject Re: How to watch for schema changes
Date
Msg-id CAKFQuwZsZvOj-XH8APjzfteD+-7XHE+tVunLLvqXgd76W0fu2w@mail.gmail.com
Whole thread Raw
In response to Re: How to watch for schema changes  (Igor Korot <ikorot01@gmail.com>)
Responses Re: How to watch for schema changes  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
On Tue, Jul 3, 2018 at 11:41 AM, Igor Korot <ikorot01@gmail.com> wrote:
​​

I presume threre is a query which check for the function/trigger
existence? Something like:

IF NOT EXIST(SELECT * FROM ) CREATE OR REPLACE FUNCTION....;

​CREATE OR REPLACE is how you re-create a function that (whose name/signature) might already exist​; CREATE already assumes one doesn't exist.

David J.

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: How to watch for schema changes
Next
From: Adrian Klaver
Date:
Subject: Re: How to watch for schema changes