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 vote274 views1 answer
How to set all the min and sec data to zero in sql server
SQL
4 votes281 views2 answers
Mysql delete user if exists
SQL
0 vote284 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
5 votes299 views2 answers
Oracle find all tables with column name
SQL
2 votes255 views1 answer
Convert series number to date in sql
SQL
4 votes273 views1 answer
Force drop all tables postgres
SQL
1 vote283 views1 answer
Mysql not supported auth mode
SQL
0 vote293 views1 answer
Shortcut run sql pgadmin
SQL
0 vote296 views1 answer
Postgresql replace html tags from string
SQL
0 vote289 views1 answer
Get a list of tables and the primary key
SQL