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

-2 votes121 views2 answers
Union vs union all in sql
SQL
12 votes109 views2 answers
Insert multiple rows from another table sql
SQL
0 vote121 views1 answer
Mysql get nth highest
SQL
2 votes116 views5 answers
SQL trigger
SQL
1 vote125 views1 answer
UseSqlServer no definition
SQL
4 votes113 views3 answers
Sqlite show columns
SQL
0 vote163 views1 answer
Postgres dump sql insert
SQL
1 vote115 views1 answer
Change table to innodb mysql
SQL
4 votes112 views1 answer
Sql quote in string
SQL
1 vote95 views1 answer
Sql auto timestamp
SQL