PL/pgSQL Variables

PHOTO EMBED

Wed Apr 14 2021 17:24:00 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

do $$ 
declare
   counter    integer := 1;
   first_name varchar(50) := 'John';
   last_name  varchar(50) := 'Doe';
   payment    numeric(11,2) := 20.5;
begin 
   raise notice '% % % has been paid % USD', 
       counter, 
	   first_name, 
	   last_name, 
	   payment;
end $$;
Code language: PostgreSQL SQL dialect and PL/pgSQL (pgsql)
content_copyCOPY

https://www.postgresqltutorial.com/plpgsql-variables/