From 294ed868ffd8f4220acf264e7273918c56d159e7 Mon Sep 17 00:00:00 2001 From: Mischa POSLAWSKY Date: Sun, 16 Feb 2020 22:08:16 +0100 Subject: [PATCH] postgresql client invocation example Personal favourite to quickly visualise statistics. --- barcat | 4 ++++ 1 file changed, 4 insertions(+) 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 | -- 2.30.0