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

8 votes190 views2 answers
Mysql query dates between two dates
SQL
0 vote195 views1 answer
Difference between varchar and varchar2
SQL
1 vote224 views1 answer
Sql and
SQL
1 vote218 views1 answer
Mysql show current queries
SQL
2 votes229 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote204 views1 answer
GROUP BY postgres
SQL
0 vote201 views1 answer
Postgresql delete multiple rows
SQL
0 vote364 views1 answer
The package java.sql is not accessible
SQL
2 votes249 views1 answer
Match in sql server
SQL
5 votes280 views1 answer
Mysql last day of next month
SQL