Re: Determine server version from psql script - Mailing list pgsql-general

From Igor Korot
Subject Re: Determine server version from psql script
Date
Msg-id CA+FnnTz9-cjBDf3mC9fx_FCtZGDTneF9=w8LpTRdwCfxHN86yw@mail.gmail.com
Whole thread Raw
In response to Re: Determine server version from psql script  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Determine server version from psql script
List pgsql-general
Hi, Adrian,

On Sat, Mar 22, 2025, 7:42 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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?

What do you mean?
Its just a text file with bunch of create table/insert into


Is it actually running in psql?

Yes, i run "psql - d draft -a -f <filename>



>
> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Nested Stored Procedures - ERROR: invalid transaction termination 2D000
Next
From: "David G. Johnston"
Date:
Subject: Re: Determine server version from psql script