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

0 vote124 views1 answer
Mariadb maximum left join
SQL
4 votes142 views3 answers
Is not null sql
SQL
1 vote138 views1 answer
Does insert into overwrite sql
SQL
36 votes120 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote124 views1 answer
Default column value in sql same as other column
SQL
1 vote133 views1 answer
Altering the column name in MySQL to have a default value
SQL
4 votes133 views3 answers
Sqlite show columns
SQL
0 vote137 views1 answer
Tinydb add table
SQL
0 vote138 views1 answer
Hoq to import database source
SQL
2 votes128 views1 answer
Import database in mysql command line xampp
SQL