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 vote172 views1 answer
Insert set mysql
SQL
0 vote205 views1 answer
Mysql backup query
SQL
0 vote180 views1 answer
How to query all tables mysql at the same time
SQL
2 votes205 views1 answer
Pandas to sql index
SQL
0 vote224 views1 answer
Mysql show foreign keys column
SQL
1 vote185 views1 answer
Sql select whole row max column
SQL
0 vote200 views1 answer
Connect to nginx server mysql remotly
SQL
1 vote167 views2 answers
Mysql filter by date mount
SQL
3 votes192 views1 answer
Oracle list invalid password logon denied
SQL
1 vote206 views3 answers
How to create a table structure from another table in mysql
SQL