Revision 8217
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/FIA/occurrence_all/import | ||
|---|---|---|
| 5 | 5 |
|
| 6 | 6 |
psql <<'EOF' |
| 7 | 7 |
DROP VIEW IF EXISTS occurrence_all; |
| 8 |
CREATE OR REPLACE VIEW occurrence_all AS
|
|
| 8 |
CREATE OR REPLACE VIEW occurrence_all AS |
|
| 9 | 9 |
SELECT * |
| 10 | 10 |
/* directional joins needed for PostgreSQL query planner to avoid slow sorts |
| 11 | 11 |
(when LIMIT <= 1.3 million rows) */ |
Also available in: Unified diff
inputs/FIA/occurrence_all/import: Removed trailing whitespace