Revision 4448
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/input.Makefile | ||
|---|---|---|
| 209 | 209 |
echo 'ALTER TABLE "$*" ADD COLUMN row_num serial NOT NULL PRIMARY KEY;'; \ |
| 210 | 210 |
echo 'VACUUM ANALYZE "$*";')|$(psqlAsBien) --echo-all |
| 211 | 211 |
(prefix=; . $(bin)/vegbien_dest; env schema=$(datasrc) table=$* \ |
| 212 |
errors_table_only=1 $(bin)/csv2db)
|
|
| 212 |
$(bin)/csv2db) |
|
| 213 | 213 |
echo 'SELECT * FROM "$(datasrc)"."$*" LIMIT 0;'|$(psqlAsBien) \ |
| 214 | 214 |
--no-align --field-separator=, --pset=footer=off >$*/header.csv |
| 215 | 215 |
|
Also available in: Unified diff
input.Makefile: Staging tables installation: `%/install: %/create.sql`: Removed deprecated (but benign) errors_table_only option to csv2db. Run csv2db without a command in order to clean up the created staging table.