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 vote190 views1 answer
Psql connections
SQL
8 votes198 views1 answer
Declare table variable sql server
SQL
0 vote283 views1 answer
Mysql failed to login as root@localhost
SQL
2 votes221 views2 answers
Mysql write into table
SQL
2 votes180 views1 answer
Oracle apex list connected users
SQL
0 vote203 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote175 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
1 vote511 views1 answer
Mysql event last execution
SQL
1 vote399 views1 answer
How to make a select in sql
SQL
0 vote221 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL