Re: PSQL commands: \quit_if, \quit_unless - Mailing list pgsql-hackers

Yes, that is a possibility, but this can already be queried into a :-variable, so it is less indispensable.

can you show some examples, please?

 SELECT COUNT(*) AS has_unit_extension
   FROM pg_extension WHERE extname='unit' \gset
 \echo :has_unit_extension
 1

So that

 \if ! :hash_unit_extension
 CREATE TABLE foo(id SERIAL, stuff UNIT);
 \else
 \echo "unit extension is not loaded"
 \quit
 \fi

Ok, for this example one may try:

 CREATE EXTENSION IF NOT EXISTS unit;

Or use the "ON_ERROR_STOP" setting, but that is the idea, SQL can be used to test anything server-side.

--
Fabien.