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 vote333 views1 answer
Sql gather statistics to increase performance
SQL
0 vote332 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote353 views1 answer
Pl sql disable trigger
SQL
0 vote284 views1 answer
Import sql mysql ubuntu
SQL
-2 votes306 views3 answers
Sqlite reset autoincrement
SQL
1 vote267 views1 answer
Postgres grant read only access to database
SQL
17 votes376 views4 answers
Show all tables in oracle
SQL
2 votes321 views1 answer
Power query concatenate
SQL
1 vote314 views1 answer
Show per page table in xampp
SQL
0 vote322 views1 answer
Postgres statistics
SQL