add mig-sql the show path

[migration-tools.git] / mig-bin / mig-sql

diff --git a/mig-bin/mig-sql b/mig-bin/mig-sql
index 5b79e17..bbe564f 100755 (executable)
--- a/mig-bin/mig-sql
+++ b/mig-bin/mig-sql
@@ -31,14 +31,17 @@ my $mig_bin = "$FindBin::Bin/";
 use lib "$FindBin::Bin/";
 use Mig;
 
-pod2usage(-verbose => 2) if defined $ARGV[0] && $ARGV[0] eq '--help';
-
-system(
-    'psql',
-    '-vbibstart=' . $BIBSTART,
-    # TODO inject mig-tracked variables here
-    @ARGV
+my @MYARGV = (
+     'psql'
+    ,'options=--search_path=' . $MIGSCHEMA . ',public,evergreen,pg_catalog'
+    ,'-vmigschema=' . $MIGSCHEMA
 );
+if (defined $BIBSTART) {
+    push @MYARGV, '-vbibstart=' . $BIBSTART;
+}
+# TODO inject more mig-tracked variables here
+
+system(@MYARGV, @ARGV);
 
 exit 0;