Postgresql Fonksiyonlar

Örnek insert fonksiyonu :

CREATE FUNCTION insert_machines()
RETURNS void AS
$$
BEGIN
insert into "nespressoAPI_machines" (name) values
('C85 EXPERT MILK OFF BLACK'),
('D500MAESTRIA CREMA'),
('D80 EXPERT ANTHRACITE GREY'),
('D85 EXPERT MILK ANTHRACITE GREY'),
('ESSENZA MINI C 30 BLACK'),
('ESSENZA MINI C 30 WHITE'),
('ESSENZA MINI C 35 BLACK BUNDLE'),
('ESSENZA MINI D 30 RED'),
('ESSENZA MINI D 35 RED BUNDLE'),
('F 111 LATTISSIMA ONE BROWN'),
('F 111 LATTISSIMA ONE WHITE'),
('F 456 LATTISSIMA PRO'),
('F 511 LATTISSIMA BLACK RESTYLE'),
('F 511 LATTISSIMA RED RESTYLE'),
('F 511 LATTISSIMA WHITE RESTYLE'),
('F 521 LATTISSIMA BLACK'),
('F 521 LATTISSIMA SILVER'),
('F 521 LATTISSIMA WHITE'),
('F411 LATTISSIMA + RED'),
('INISSIA C 45 RED&AERO3'),
('KLASIK ARPEGGIO KAHVE'),
('MAKINE KLASIK C 40 INISSIA RED'),
('MAKINE KLASIK D 40 INISSIA BLACK'),
('OUTLET MAKINE KLASIK C 40 INISSIA RED V269'),
('U D50 PURE BLACK'),
('UC50 MAT RED'),
('UC55 U&MILK CREAM'),
('UD50 MAT GREY');
END
$$
LANGUAGE 'plpgsql';