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

-1 vote228 views1 answer
Mysql faster insert
SQL
0 vote225 views1 answer
Sql date with year
SQL
25 votes183 views6 answers
Modify column name in mysql
SQL
0 vote206 views1 answer
Datatables server side filter where clause
SQL
6 votes208 views2 answers
Postgresql database url
SQL
28 votes204 views4 answers
Delete database mysql
SQL
2 votes192 views1 answer
Laravel sql String
SQL
4 votes205 views1 answer
Search column by name mysql
SQL
1 vote205 views1 answer
Error code 1292 mysql workbench
SQL
0 vote194 views1 answer
Flask sqlalchemy remove duplicates
SQL