From 3d4d538d2127b69c73e3566c7f7eb0ce6cd542f2 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 13 Mar 2018 11:24:37 -0400 Subject: [PATCH] making sure gsheet --export output uses tab delimiter --- mig-bin/mig-gsheet | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/mig-bin/mig-gsheet b/mig-bin/mig-gsheet index a4e089c..9cad4ab 100755 --- a/mig-bin/mig-gsheet +++ b/mig-bin/mig-gsheet @@ -190,7 +190,7 @@ sub export_table { my $efile = $MIGGITDIR . $table . '_' . $date . '_' . $hms . '.tsv'; my @data; my $record_count = 0; - $dbh->do("COPY $table TO STDOUT CSV HEADER;"); + $dbh->do("COPY $table TO STDOUT CSV DELIMITER E'\t' HEADER;"); 1 while $dbh->pg_getcopydata(\$data[$record_count++]) >= 0; open (my $eout, '>', $efile) or abort("Could NOT open $efile."); foreach my $d (@data) { @@ -203,7 +203,7 @@ sub export_table { sub die_if_gsheet_tracked_table_does_not_exist { if (!check_for_gsheet_tracked_table()) { - die "Table $MIGSCHEMA.gsheet_tracked_table does not exist. Bailing...\n"; + die "Table gsheet_tracked_table does not exist. Bailing...\n"; } } -- 1.7.2.5