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 vote91 views4 answers
Sequelize migration default value
SQL
7 votes102 views1 answer
Minecraft forge server host
SQL
0 vote118 views1 answer
Redshift running queries
SQL
1 vote91 views1 answer
Set statistics on in ssms
SQL
1 vote86 views1 answer
Tsql random number
SQL
20 votes112 views4 answers
Sql count if
SQL
0 vote104 views2 answers
Sql select inside select
SQL
0 vote102 views1 answer
Sql column as header
SQL
0 vote139 views1 answer
Mysql grant access to one database
SQL
2 votes110 views1 answer
Q operator in sql
SQL