From d7db725d83357c0988c2990d55bb6de3cbe91781 Mon Sep 17 00:00:00 2001
From: Andreas Gerler <baron@bundesbrandschatzamt.de>
Date: Mon, 31 Jul 2017 18:18:24 +0200
Subject: [PATCH] snippet: vertica-cp-table

snippet to truncate and copy a table via vertica connect.

Signed-off-by: Andreas Gerler <baron@bundesbrandschatzamt.de>
---
 snippets/sql-mode/vertica-cp-table | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 snippets/sql-mode/vertica-cp-table

diff --git a/snippets/sql-mode/vertica-cp-table b/snippets/sql-mode/vertica-cp-table
new file mode 100644
index 00000000..ebce9dca
--- /dev/null
+++ b/snippets/sql-mode/vertica-cp-table
@@ -0,0 +1,6 @@
+# -*- mode: snippet -*-
+# name: vertica-cp-table
+# key: cp-table
+# --
+TRUNCATE TABLE $1.$2;
+COPY $1.$2 FROM VERTICA $3.$1.$2 DIRECT;
\ No newline at end of file
-- 
2.47.3