testing_environments_path

DROP FUNCTION IF EXISTS testing_environments_path(text);
CREATE OR REPLACE FUNCTION testing_environments_path(
  dbschema text
  )
  RETURNS void AS
  $$
BEGIN
  EXECUTE format('CREATE SCHEMA %I;', dbschema);
  EXECUTE format('SET LOCAL search_path TO %I,public', dbschema);

  CREATE TABLE testing_table_to_delete (
    id serial PRIMARY KEY,
    name text
  );
  
  INSERT INTO testing_table_to_delete (name)
    VALUES
    ('one'), ('two'), ('three');

END;
$$ LANGUAGE plpgsql;