Restore tables from a snapshot into public.

snapshot_restore.sql

DO
$$
DECLARE
    hidden_table record;
BEGIN
    FOR hidden_table IN 
	SELECT schemaname, tablename FROM pg_tables 
	WHERE schemaname = (SELECT MAX(schemaname) FROM pg_tables WHERE schemaname LIKE 'snapshot_%')
    LOOP
	EXECUTE 'DROP TABLE IF EXISTS public.' || quote_ident(hidden_table.tablename) || ';';
        EXECUTE 'ALTER TABLE ' || quote_ident(hidden_table.schemaname) || '.' || quote_ident(hidden_table.tablename) || ' SET SCHEMA public;';
    END LOOP;
END;
$$;