MIME-Version: 1.0
References: <CA+FnnTyWEsYi=_QTeSXoGXd7Fkd8C7_AnCc5=hho-DZF9_iunQ@mail.gmail.com>
 <90741d5f-5cda-4c4a-84f4-c470129732f4@aklaver.com>
In-Reply-To: <90741d5f-5cda-4c4a-84f4-c470129732f4@aklaver.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sat, 22 Mar 2025 20:47:05 -0500
Message-ID: <CA+FnnTz9-cjBDf3mC9fx_FCtZGDTneF9=w8LpTRdwCfxHN86yw@mail.gmail.com>
Subject: Re: Determine server version from psql script
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000dcfccd0630f8aa4f"
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTz9-cjBDf3mC9fx_FCtZGDTneF9%3Dw8LpTRdwCfxHN86yw%40mail.gmail.com>
Precedence: bulk

--000000000000dcfccd0630f8aa4f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi, Adrian,

On Sat, Mar 22, 2025, 7:42=E2=80=AFPM 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
>
>

--000000000000dcfccd0630f8aa4f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div>Hi, Adrian,<br><br><div class=3D"gmail_quote gmail_q=
uote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Mar 22, 2025,=
 7:42=E2=80=AFPM Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.=
com">adrian.klaver@aklaver.com</a>&gt; wrote:<br></div><blockquote class=3D=
"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding=
-left:1ex">On 3/22/25 17:31, Igor Korot wrote:<br>
&gt; Hi, All,<br>
&gt; I have a big script that populated the DB for me.<br>
<br>
The language used for the script?<br></blockquote></div></div><div dir=3D"a=
uto"><br></div><div dir=3D"auto">What do you mean?</div><div dir=3D"auto">I=
ts just a text file with bunch of create table/insert into</div><div dir=3D=
"auto"><br></div><div dir=3D"auto"><div class=3D"gmail_quote gmail_quote_co=
ntainer"><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;borde=
r-left:1px #ccc solid;padding-left:1ex">
<br>
Is it actually running in psql?<br></blockquote></div></div><div dir=3D"aut=
o"><br></div><div dir=3D"auto">Yes, i run &quot;psql - d draft -a -f &lt;fi=
lename&gt;</div><div dir=3D"auto"><br></div><div dir=3D"auto"><br></div><di=
v dir=3D"auto"><div class=3D"gmail_quote gmail_quote_container"><blockquote=
 class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc soli=
d;padding-left:1ex">
<br>
&gt; <br>
&gt; I made it based on the latest available version.<br>
&gt; <br>
&gt; However,=C2=A0 i have version 13 installed on my Linux box and so tryi=
ng to <br>
&gt; execute &quot;CREATE OR REPLACE TRIGGER...&quot; will fail.<br>
&gt; <br>
&gt; Is there a way to determine the server version from such a script?<br>
<br>
=C2=A0From here:<br>
<br>
<a href=3D"https://www.postgresql.org/docs/13/runtime-config-preset.html#GU=
C-SERVER-VERSION-NUM" rel=3D"noreferrer noreferrer" target=3D"_blank">https=
://www.postgresql.org/docs/13/runtime-config-preset.html#GUC-SERVER-VERSION=
-NUM</a><br>
<br>
show server_version_num;<br>
<br>
Though how you use that is going to depend on the answers to the first <br>
two questions.<br>
<br>
&gt; <br>
&gt; Thank you.<br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank" rel=3D"noref=
errer">adrian.klaver@aklaver.com</a><br>
<br>
</blockquote></div></div></div>

--000000000000dcfccd0630f8aa4f--