From 9e0833d67b07519d78d4fb111839f575fb5b2f0d Mon Sep 17 00:00:00 2001 From: Andreas Gerler Date: Wed, 30 Nov 2016 17:06:53 +0100 Subject: [PATCH] snippets for sql-interactive - some snippets for interactive Vertica SQL. Signed-off-by: Andreas Gerler --- snippets/sql-interactive-mode/grants_resourcepool | 5 +++++ snippets/sql-interactive-mode/vertica_users | 5 +++++ 2 files changed, 10 insertions(+) create mode 100644 snippets/sql-interactive-mode/grants_resourcepool create mode 100644 snippets/sql-interactive-mode/vertica_users diff --git a/snippets/sql-interactive-mode/grants_resourcepool b/snippets/sql-interactive-mode/grants_resourcepool new file mode 100644 index 00000000..3205b92e --- /dev/null +++ b/snippets/sql-interactive-mode/grants_resourcepool @@ -0,0 +1,5 @@ +# -*- mode: snippet -*- +# name: grants_resourcepool +# key: grares_ +# -- +SELECT grantee, object_name FROM grants WHERE object_type = 'RESOURCEPOOL' ORDER BY grantee LIMIT 50; \ No newline at end of file diff --git a/snippets/sql-interactive-mode/vertica_users b/snippets/sql-interactive-mode/vertica_users new file mode 100644 index 00000000..6fdaff03 --- /dev/null +++ b/snippets/sql-interactive-mode/vertica_users @@ -0,0 +1,5 @@ +# -*- mode: snippet -*- +# name: vertica_users +# key: vertu_ +# -- +SELECT user_name,resource_pool,default_roles FROM users ORDER BY 1; \ No newline at end of file -- 2.47.3