#!/bin/bash
#
# Pipe this to psql:
#
# bash cursors.sh | psql
#

echo "BEGIN;"
for ((i=0; i < 1000; i++))
do
    echo "DECLARE cur$i CURSOR FOR SELECT generate_series(1, 5);"
done
for ((i=0; i < 1000000; i++))
do
    echo "SAVEPOINT sp$i;"
done
for ((i=0; i < 1000; i++))
do
    echo "CLOSE cur$i;"
done
echo "COMMIT;"