script.sql

text/x-sql

Filename: script.sql
Type: text/x-sql
Part: 0
Message: custom variables and PGC_SUSET issue
--load 'plpgsql';

\set VERBOSITY verbose

set plpgsql.variable_conflict = use_variable;

\echo before create function

create or replace function test1(a integer) returns integer as $$
begin
return a+1;
end;
$$ language plpgsql;

\echo after function