On 3/22/25 17:31, Igor Korot wrote:
Hi, All,
I have a big script that populated the DB for me.
The language used for the script?
Is it actually running in psql?
I made it based on the latest available version.
However, i have version 13 installed on my Linux box and so trying to
execute "CREATE OR REPLACE TRIGGER..." will fail.
Is there a way to determine the server version from such a script?
From here:
https://www.postgresql.org/docs/13/runtime-config-preset.html#GUC-SERVER-VERSION-NUM
show server_version_num;
Though how you use that is going to depend on the answers to the first
two questions.
Thank you.
--
Adrian Klaver
adrian.kla...@aklaver.com
