could not create pg-notify extension in pgadmin

Question

CREATE EXTENSION IF NOT EXISTS pg_notify; could not execute this command in pgadmin .

I am getting the following error: ERROR: could not open extension control file "C:/Program Files/PostgreSQL/14/share/extension/pg_notify.control": No such file or directory

Answer 1

I am not sure what you're trying to do. pg_notify is not an extension, it is instead a function, according to this documentation. The signature of the function is pg_notify(text, text). The function takes the channel name as the first argument and the payload as the second.

Alternatively, you can send a notification as:

NOTIFY my_channel, 'Hello, world!';

and listen to it as follows:

LISTEN my_channel;