Re: [PATCH] Implement motd for PostgreSQL - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: [PATCH] Implement motd for PostgreSQL
Date
Msg-id 7d70b3d2-3a36-45f0-8753-96bf6397b972@www.fastmail.com
Whole thread Raw
In response to Re: [PATCH] Implement motd for PostgreSQL  ("Joel Jacobson" <joel@compiler.org>)
List pgsql-hackers
On Sun, Apr 4, 2021, at 07:55, Joel Jacobson wrote:
On Sat, Apr 3, 2021, at 17:50, Fabien COELHO wrote:
I'm wondering whether it should be possible to designate (1) a file the 
content of which would be shown, or (2) a command, the output of which 
would be shown [ok, there might be security implications on this one].

Can't we just do that via plpgsql and EXECUTE somehow?

Right, we can't since

ERROR:  ALTER SYSTEM cannot be executed from a function

I wrongly thought a PROCEDURE would work, but it gives the same error.

/Joel

pgsql-hackers by date:

Previous
From: "Joel Jacobson"
Date:
Subject: Re: [PATCH] Implement motd for PostgreSQL
Next
From: Kazutaka Onishi
Date:
Subject: Re: TRUNCATE on foreign table