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 vote274 views1 answer
Sql try catch
SQL
3 votes320 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
0 vote284 views1 answer
Lesser than or equal to symbol in postgres
SQL
1 vote318 views1 answer
Postgres left join
SQL
0 vote276 views1 answer
Mysql workbench not showing schemas
SQL
2 votes275 views1 answer
Postgresql add entry to table
SQL
0 vote284 views1 answer
Ignore case in string sql
SQL
6 votes299 views2 answers
Insert into select mysql
SQL
3 votes309 views4 answers
Ubuntu stop mysql
SQL
0 vote288 views2 answers
SQL FROM
SQL