Project

General

Profile

« Previous | Next » 

Revision 4463

Added by Aaron Marcuse-Kubitza about 12 years ago

my2pg: Prepend 'SET standard_conforming_strings = off;' because this defaults to on starting with PostgreSQL 9.1

View differences:

inputs/SALVIAS/salvias_plots.schema.sql
1 
SET standard_conforming_strings = off;
1 2 
-- MySQL dump 10.13  Distrib 5.5.24, for debian-linux-gnu (x86_64)
2 3 
--
3 4 
-- Host: localhost    Database: salvias_plots
bin/my2pg
8 8 

  		




  9
  9
  
    
sed () { "$(which sed)" -"$sedEreFlag" "$@";}


  		




  10
  10
  
    

  		




  
  11
  
    
echo 'SET standard_conforming_strings = off;'


  		




  11
  12
  
    
sed \


  		




  12
  13
  
    
-e 's/^  KEY "([^"]*)" \([^)]*\)/  "\1_index" boolean/' \


  		




  13
  14
  
    
-e "s/\/\*.* (SET NAMES )([0-9A-Za-z_]+) \*\/;/\1'\2';/" \


  		












Also available in:  Unified diff