Skip to content

Instantly share code, notes, and snippets.

@vadviktor
Created August 30, 2012 14:24
Show Gist options
  • Save vadviktor/3529541 to your computer and use it in GitHub Desktop.
Save vadviktor/3529541 to your computer and use it in GitHub Desktop.
Custom Postgresql log highlighter
#!/usr/bin/bash
timestamp='s/\[[a-zA-Z]\+:[a-zA-Z_0-9]\+@[0-9\-]\+\ [0-9:]\+\ [A-Z]\+]/\o033[0;31;48m&\o033[0m/g'
log='s/LOG/\o033[1;34;47m&\o033[0m/g'
statement='s/STATEMENT/\o033[1;34;40m&\o033[0m/g'
warning='s/WARNING/\o033[1;31;43m&\o033[0m/g'
error='s/ERROR/\o033[1;37;41m&\o033[0m/g'
select='s/\(select\|SELECT\)/\o033[4;34;48m&\o033[0m/g'
insert='s/\(insert\|INSERT\)/\o033[4;32;48m&\o033[0m/g'
update='s/\(update\|UPDATE\)/\o033[4;33;48m&\o033[0m/g'
delete='s/\(delete\|DELETE\)/\o033[4;35;48m&\o033[0m/g'
rollback='s/ROLLBACK/\o033[1;33;40m&\o033[0m/g'
colorization=$timestamp';'$log';'$statement';'$warning';'$error';'$insert';'$update';'$delete';'$rollback';'$select
tail -f $1 | sed -e "$colorization"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment