From: Mischa POSLAWSKY <perl@shiar.org>
Date: Sun, 16 Feb 2020 21:08:16 +0000 (+0100)
Subject: postgresql client invocation example
X-Git-Tag: v1.07~1
X-Git-Url: http://git.shiar.nl/barcat.git/commitdiff_plain/294ed868ffd8f4220acf264e7273918c56d159e7

postgresql client invocation example

Personal favourite to quickly visualise statistics.
---

diff --git a/barcat b/barcat
index a571a25..e875d07 100755
--- a/barcat
+++ b/barcat
@@ -536,6 +536,10 @@ Any kind of database query with counts, preserving returned alignment:
     echo 'SELECT count(*),schemaname FROM pg_tables GROUP BY 2' |
     psql -t | barcat -u
 
+In PostgreSQL from within the client:
+
+	postgres=> SELECT sin(generate_series(0, 3, .1)) \g |barcat
+
 Earthquakes worldwide magnitude 1+ in the last 24 hours:
 
     https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/1.0_day.csv |