From: Jason Etheridge <jason@esilibrary.com>
Date: Sat, 9 Sep 2017 02:51:38 +0000 (-0400)
Subject: psql variable for :migschema
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=6bce095b60d0abfd401ebf8f69a78146864645b7

psql variable for :migschema

mig-sql already puts the migration schema in the search path, but
this can be useful for things like

    creator = (SELECT id FROM actor_usr WHERE usrname = :'migschema' || '_admin')

Signed-off-by: Jason Etheridge <jason@esilibrary.com>
---

diff --git a/mig-bin/mig-sql b/mig-bin/mig-sql
index c218076..0f7d9e0 100755
--- a/mig-bin/mig-sql
+++ b/mig-bin/mig-sql
@@ -34,7 +34,8 @@ use Mig;
 pod2usage(-verbose => 2) if defined $ARGV[0] && $ARGV[0] eq '--help';
 
 my @MYARGV = (
-    'psql'
+     'psql'
+    ,'-vmigschema=' . $MIGSCHEMA
 );
 if (defined $BIBSTART) {
     push @MYARGV, '-vbibstart=' . $BIBSTART;