use strict;

print <<EOT;

CREATE EXTENSION IF NOT EXISTS btree_gist;
DROP TABLE IF EXISTS t;

CREATE TABLE t (
				id int,
				v int
);

\\COPY t FROM stdin
EOT

for my $i (1..10000) {
	print "$i\t0\n";
}
print "\\.\n";

print "CREATE INDEX i ON t USING gist (id);\n";