Project

General

Profile

« Previous | Next » 

Revision 4429

input.Makefile: Staging tables installation: Also translate MySQL data to PostgreSQL

View differences:

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