Revision 14413
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 582 | 582 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
| 583 | 583 |
$ make schemas/remake |
| 584 | 584 |
|
| 585 |
to remove a column: |
|
| 586 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
|
| 585 |
to remove a derived column:
|
|
| 586 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''col''));
|
|
| 587 | 587 |
$ make schemas/remake |
| 588 | 588 |
|
| 589 |
to remove a non-derived column: |
|
| 590 |
SELECT util.drop_column((''"TNRS".taxon_match'', ''col''));
|
|
| 591 |
$ make schemas/remake |
|
| 592 |
|
|
| 589 | 593 |
to move a derived column to the middle or to add a non-derived column: |
| 590 | 594 |
make the changes in inputs/.TNRS/schema.sql |
| 591 | 595 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS; runtime: 1 min ("1m2.629s")
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 20243 | 20243 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
| 20244 | 20244 |
$ make schemas/remake |
| 20245 | 20245 |
|
| 20246 |
to remove a column: |
|
| 20247 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
|
| 20246 |
to remove a derived column:
|
|
| 20247 |
SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''col''));
|
|
| 20248 | 20248 |
$ make schemas/remake |
| 20249 | 20249 |
|
| 20250 |
to remove a non-derived column: |
|
| 20251 |
SELECT util.drop_column((''"TNRS".taxon_match'', ''col''));
|
|
| 20252 |
$ make schemas/remake |
|
| 20253 |
|
|
| 20250 | 20254 |
to move a derived column to the middle or to add a non-derived column: |
| 20251 | 20255 |
make the changes in inputs/.TNRS/schema.sql |
| 20252 | 20256 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS; runtime: 1 min ("1m2.629s")
|
Also available in: Unified diff
fix: inputs/.TNRS/schema.sql: taxon_match: to remove a column: updated instructions