Re: Determine server version from psql script
| От | Igor Korot |
|---|---|
| Тема | Re: Determine server version from psql script |
| Дата | |
| Msg-id | CA+FnnTz9-cjBDf3mC9fx_FCtZGDTneF9=w8LpTRdwCfxHN86yw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Determine server version from psql script (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: Determine server version from psql script
|
| Список | 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 по дате отправления: