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 vote339 views1 answer
Get rows affected mysql python
SQL
5 votes349 views1 answer
JBDC
SQL
0 vote362 views1 answer
Varchar2 length in oracle
SQL
3 votes338 views1 answer
Ssh check mysql version
SQL
0 vote355 views1 answer
How to change null display in psql
SQL
0 vote340 views1 answer
How to find top 3 salary in sql
SQL
0 vote322 views0 answer
SQL
0 vote343 views1 answer
Query on date sqlite flutter
SQL
-1 vote360 views1 answer
Partial search in sql
SQL
1 vote368 views1 answer
Wherein mysql
SQL