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 votes239 views5 answers
Tablespace ORACLE
SQL
0 vote196 views1 answer
Monthly Birthday SQL Query
SQL
0 vote272 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote195 views1 answer
Increment id in mysql
SQL
1 vote207 views1 answer
Alter add syntax
SQL
11 votes210 views2 answers
Safe mode off mysql
SQL
8 votes188 views2 answers
Phpmyadmin password
SQL
1 vote254 views1 answer
Count of tables in database mysql
SQL
0 vote196 views1 answer
Grepper sql workbench download
SQL
0 vote255 views1 answer
Delete ids between sql
SQL