top of page
CerebroSQL

PostgreSQL:  

PREPARE

PREPARE name [ ( data_type [, ...] ) ] AS statement

Example

PREPARE fooplan (int, text, bool, numeric) AS
INSERT INTO foo VALUES($1, $2, $3, $4);
EXECUTE fooplan(1, 'Hunter Valley', 't', 200.00);

bottom of page