如何使用postgresql中的存储过程将数据插入表中

CREATE TABLE app_for_leave
(
  sno integer NOT NULL,
  eid integer,
  ename varchar(20),
  sd date,
  ed date,
  sid integer,
  status boolean DEFAULT false,
  CONSTRAINT pk_snoa PRIMARY KEY (sno)
);
CREATE TABLE app_for_leave
(
  sno integer NOT