Revision 4423
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/input.Makefile | ||
|---|---|---|
| 189 | 189 |
%.sql/install: %.sql _always |
| 190 | 190 |
($(inDatasrc); grep -vF 'SET search_path' $<)|"time" $(psqlAsBien) |
| 191 | 191 |
|
| 192 |
# The export must be created with: |
|
| 193 |
# `--compatible=postgresql --add-locks=false --set-charset` |
|
| 194 |
%.pg.sql: %.my.sql |
|
| 195 |
$(bin)/my2pg <$< >$@ |
|
| 196 |
|
|
| 192 | 197 |
# For staging tables which are derived by joining together other staging tables. |
| 193 | 198 |
%/install %/header.csv: %/create.sql _always |
| 194 | 199 |
($(inDatasrc); echo 'CREATE TABLE "$*" AS'; cat $<; echo ';'; \ |
Also available in: Unified diff
input.Makefile: Staging tables installation: Added `%.pg.sql: %.my.sql` to translate MySQL DB schemas to PostgreSQL