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

6 votes221 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote198 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote211 views1 answer
Uncomment listen_address=localhost
SQL
34 votes213 views6 answers
Install mysql client ubuntu
SQL
6 votes272 views2 answers
Oracle undotbs usage
SQL
0 vote246 views1 answer
Show specific events on mysql
SQL
2 votes211 views1 answer
Mysql how to store lat,lng
SQL
24 votes218 views6 answers
Replace mysql
SQL
0 vote222 views1 answer
Flush user resource mysql
SQL
0 vote219 views1 answer
How to find sql server name
SQL