DROP VIEW test;

CREATE OR REPLACE VIEW test AS SELECT * FROM bistudio_example;

CREATE OR REPLACE PROCEDURE test()
AS $$
BEGIN
  SELECT 1 a;
END;
$$
LANGUAGE plpgsql
;
/