From 8f32f842b33bdc6617b41dc9f18b222fd3013e21 Mon Sep 17 00:00:00 2001
From: Timo Weingärtner <timo@tiwe.de>
Date: Sat, 25 Feb 2012 21:08:57 +0100
Subject: Imported Debian version 0.1

---
 plugins/psql | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100755 plugins/psql

(limited to 'plugins/psql')

diff --git a/plugins/psql b/plugins/psql
new file mode 100755
index 0000000..d1009ef
--- /dev/null
+++ b/plugins/psql
@@ -0,0 +1,25 @@
+#!/bin/dash
+
+# psql plugin
+#
+# uses psql to download a table (or view) of the form:
+# CREATE TABLE known_hosts (
+#	namelist	text, # comma seperated
+#	type		text,
+#	key		text
+# );
+#
+# ENVIRONMENT VARIABLES:
+#	TABLE		table to download
+# used by psql:
+#	PGCLUSTER	see pg_wrapper(1)
+#	PGDATABASE	see psql(1)
+#	PGUSER		..
+#	PGPASSFILE	..
+#
+
+set -e
+
+psql -F ' ' -Atc "SELECT * FROM ${TABLE}" > new
+
+# vim:set ft=sh:
-- 
cgit v1.2.3