| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Igor Korot <ikorot01(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Determine server version from psql script |
| Date: | 2025-03-23 00:42:43 |
| Message-ID: | 90741d5f-5cda-4c4a-84f4-c470129732f4@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2025-03-23 00:47:31 | Re: query_id: jumble names of temp tables for better pg_stat_statement UX |
| Previous Message | Igor Korot | 2025-03-23 00:31:45 | Determine server version from psql script |