Re: conditionally terminate psql script - Mailing list pgsql-general

From Torsten Förtsch
Subject Re: conditionally terminate psql script
Date
Msg-id CAKkG4_myzqwmHOcMRkBeJnR3HeMkbAo-u9E3AMCUSi+2Mx9CXQ@mail.gmail.com
Whole thread Raw
In response to Re: conditionally terminate psql script  (hamann.w@t-online.de)
List pgsql-general
On Mon, Dec 17, 2018 at 2:07 PM <hamann.w@t-online.de> wrote:
many thanks -- too bad I am still using 9.3


not sure if it has been mentioned in the thread so far. But according to the docs, 9.3 psql does support the \gset command. So you should be able to do something like this:

select case when exists (select 1 from pg_namespace where nspname='tf')
            then '\echo schema tf exists \\ \q'
            else '\echo schema does not exist -- creating ...'
       end as cmd\gset
:cmd

create schema tf;
create table tf.i(i int);

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: conditionally terminate psql script
Next
From: Condor
Date:
Subject: Re: Format an Update with calculation