git.shiar.nl
/
barcat.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
stable enough version 1.07
[barcat.git]
/
barcat
diff --git
a/barcat
b/barcat
index a571a257a257a3ae5d8e687898eb7a8b45c82ea0..da07ea706c7e149754edafc6465251b3f1592554 100755
(executable)
--- a/
barcat
+++ b/
barcat
@@
-5,7
+5,7
@@
use utf8;
use List::Util qw( min max sum );
use open qw( :std :utf8 );
use List::Util qw( min max sum );
use open qw( :std :utf8 );
-our $VERSION = '1.0
6
';
+our $VERSION = '1.0
7
';
use Getopt::Long '2.33', qw( :config gnu_getopt );
my %opt;
use Getopt::Long '2.33', qw( :config gnu_getopt );
my %opt;
@@
-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
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 |
Earthquakes worldwide magnitude 1+ in the last 24 hours:
https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/1.0_day.csv |