Project

General

Profile

« Previous | Next » 

Revision 6097

Added by Aaron Marcuse-Kubitza about 12 years ago

psql_vegbien: Added $no_search_path option to turn off the automatic SET search_path directive

View differences:

bin/psql_vegbien
1 1 
#!/bin/bash
2 2 
# Accesses vegbien db
3 
# Usage env [no_search_path=1] self [psql_opts...]
3 4 

  		




  4
  5
  
    
selfDir="$(dirname -- "$0")"


  		




  5
  6
  
    

  		




  ......




  7
  8
  
    

  		




  8
  9
  
    
searchPath="\"${out_schemas//,/\",\"}\""


  		




  9
  10
  
    

  		




  10
  
  
    
(echo "SET search_path TO $searchPath;"; cat)\


  		




  
  11
  
    
(test -z "$no_search_path" && echo "SET search_path TO $searchPath;"; cat)\


  		




  11
  12
  
    
|"$selfDir/postgres_vegbien" psql "$@"


  		












Also available in:  Unified diff