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

22 votes205 views3 answers
Remove all records from table mysql
SQL
3 votes214 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote210 views1 answer
Sql get year from datetime field
SQL
0 vote200 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
1 vote191 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
3 votes175 views1 answer
Sql timestamp to date
SQL
0 vote210 views1 answer
Add mysql database to power bi web
SQL
1 vote186 views1 answer
Mysql select utc time in eastern time
SQL
0 vote205 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
1 vote208 views1 answer
Sql server update column based on another table
SQL