Re: Determine server version from psql script

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