Pl/pgsql declare variable

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 $$;

Source: postgresqltutorial.com

Similar codes

9 votes235 views5 answers
Sql limit
SQL
0 vote229 views3 answers
Get free card roblox
SQL
0 vote249 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote248 views2 answers
Cambiar nombre tabla mysql
SQL
2 votes235 views2 answers
Mysql show table column comments sql
SQL
0 vote235 views1 answer
Run mssql server terminal
SQL
0 vote261 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote273 views1 answer
Alternative for LIMIT sql
SQL
5 votes240 views1 answer
Find table from column name in sql
SQL
1 vote226 views1 answer
Postgres regex remove special characters
SQL