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 votes121 views1 answer
How to remove tables from postgresql
SQL
1 vote77 views1 answer
Restart identity postgresql
SQL
2 votes114 views1 answer
Oracle list grants on procedure
SQL
10 votes121 views1 answer
User_dependencies
SQL
13 votes130 views2 answers
Sqlite rename table
SQL
2 votes112 views1 answer
Sql count having
SQL
0 vote115 views2 answers
Oracle create chain rule
SQL
0 vote112 views5 answers
Sql table intermédiaire
SQL
1 vote128 views3 answers
Divide by zero error in sql
SQL
2 votes112 views2 answers
Join update query in sql
SQL