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.klaver@aklaver.com
