PostgreSQL: Documentation: 11: CREATE PROCEDURE

PHOTO EMBED

Fri Apr 30 2021 16:48:04 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

CREATE PROCEDURE insert_data(a integer, b integer)
LANGUAGE SQL
AS $$
INSERT INTO tbl VALUES (a);
INSERT INTO tbl VALUES (b);
$$;

CALL insert_data(1, 2);
content_copyCOPY

https://www.postgresql.org/docs/11/sql-createprocedure.html