#! /bin/sh
#
# Usage: create_tables.sh <dbname> <# of tables>

PSQL=`which psql`
CREATEOBJECTLOG='createobjects.log'
DB_NAME=$1
TBL_NUM=$2

create_objects ()
{
	cat << EOF | psql -d ${DB_NAME} >> ${CREATEOBJECTLOG}
\timing on

DO \$\$
DECLARE
	k int;
	tablename text;
BEGIN
	FOR k IN 1 .. ${TBL_NUM} LOOP
		tablename := 'tbl_' || k;
		EXECUTE 'CREATE TABLE ' || tablename || ' (
			big01 bigint,
			big02 bigint,
			big03 bigint)';
	END LOOP;
END;
\$\$ LANGUAGE plpgsql;
EOF
}

time create_objects