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 vote175 views1 answer
Scaffold mysql database
SQL
0 vote186 views1 answer
Running percentage of total postgres
SQL
0 vote209 views1 answer
Get substract count sql
SQL
1 vote173 views1 answer
Not exists mysql
SQL
1 vote214 views1 answer
Sql select row with max date
SQL
0 vote196 views1 answer
Query for backup a database at another location in file system
SQL
0 vote199 views1 answer
Mssql unique key accept nulls
SQL
-1 vote177 views1 answer
Mysql select all columns and specific fields as
SQL
1 vote170 views1 answer
Xampp import sql file command line
SQL
10 votes194 views2 answers
Mysql drop database if exists
SQL