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