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

0 vote391 views1 answer
Show specific events on mysql
SQL
0 vote359 views1 answer
Mysql disable query caching
SQL
0 vote378 views1 answer
Set Mamp mysql globally
SQL
-1 vote364 views1 answer
Get id from just inserted row mysql server python
SQL
25 votes364 views6 answers
Modify column name in mysql
SQL
0 vote400 views1 answer
Create table in dbms cmds
SQL
4 votes387 views4 answers
Date less than in sql
SQL
0 vote353 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote371 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote343 views1 answer
Postgresql create user roles
SQL