Product Documentation

Appearance

7.1.2
7.0.2
6.9.3
5.4.17
5.2.31
All platforms

EXECUTE ​

Execute a prepared statement.

EXECUTE name [ ( parameter [, ...] ) ]

To execute a prepared statement, supply its name and a list of parameter values. See PREPARE.

For example:

premdb=# prepare insert_team(int,varchar(30),varchar(20),varchar(20),varchar(50),int) 
as insert into hometeam values($1, $2, $3, $4, $5, $6);
PREPARE
premdb=# execute insert_team(20,'Arsenal','The Gunners','London','Emirates Stadium',60260);
INSERT 0 1
premdb=# select * from hometeam;
 htid |       name        |  nickname   |    city    |      stadium       | capacity 
------+-------------------+-------------+------------+--------------------+----------
   20 | Arsenal           | The Gunners | London     | Emirates Stadium   |    60260
   1 | Manchester United | Red Devils  | Manchester | Old Trafford       |    75635
  200 | Tottenham Hotspur | Spurs       | London     | White Hart Lane    |    36284
   2 | Leicester City    | Foxes       | Leicester  | King Power Stadium |    32262
(4 rows)