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