|
Revision 46, 0.6 kB
(checked in by cs186, 4 years ago)
|
|
California data set, add to README and setup.sql
|
| Line | |
|---|
| 1 | create table test(id integer, the_box box); |
|---|
| 2 | copy test from '/home/cc/cs186/fa07/coass/cs186-XX/Hw2/MyStuff/randomboxes' delimiter ';' ; |
|---|
| 3 | create index ix1 on test using gist (the_box box_ops); |
|---|
| 4 | create table test25 (id integer, the_box box); |
|---|
| 5 | copy test25 from '/home/cc/cs186/fa07/class/cs186-XX/Hw2/MyStuff/randomboxes25' delimiter ';' ; |
|---|
| 6 | create index ix2 on test25 using gist (the_box box_ops); |
|---|
| 7 | create table cali(location box, name text); |
|---|
| 8 | copy cali from '/home/cc/cs186/fa07/class/cs186-XX/Hw2/MyStuff/cali.txt' delimiter '|'; |
|---|
| 9 | create index cali_ix on cali using gist(location box_ops); |
|---|
