Project

General

Profile

« Previous | Next » 

Revision 8191

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/*functions.sql: Renamed to *util.sql because now that these schemas are used by the new-style import scripts, there can be more than just functions in them

View differences:

lib/import.sh
19 19 

  		




  20
  20
  
    
psql ()


  		




  21
  21
  
    
{


  		




  22
  
  
    
	(echo "SET search_path TO \"$schema\", functions;"; cat)|


  		




  
  22
  
    
	(echo "SET search_path TO \"$schema\", util;"; cat)|


  		




  23
  23
  
    
	env no_search_path=1 "$bin_dir"/psql_verbose_vegbien


  		




  24
  24
  
    
}


  		




  25
  25
  
    

  		




  ......




  27
  27
  
    
{


  		




  28
  28
  
    
	make --directory=.. --makefile=../input.Makefile "$table"/map.csv


  		




  29
  29
  
    
	(psql <<EOF


  		




  30
  
  
    
SELECT functions.reset_map_table('pg_temp.map');


  		




  
  30
  
    
SELECT util.reset_map_table('pg_temp.map');


  		




  31
  31
  
    
\copy pg_temp.map FROM 'map.csv' CSV HEADER;


  		




  32
  
  
    
SELECT functions.set_col_names('"$table"', 'pg_temp.map'::regclass);


  		




  
  32
  
    
SELECT util.set_col_names('"$table"', 'pg_temp.map'::regclass);


  		




  33
  33
  
    
EOF


  		




  34
  34
  
    
	)


  		




  35
  35
  
    
}


  		












Also available in:  Unified diff