Combine postgres log lines to put sql queries on a single line

ak_combine_sql

#!/bin/awk -f
#
# Handles combining log lines from postgres since the statements can have new lines in
# We identify the 2 classes of lines by the timestamp (or not) at the start of the line
#
# This makes grepping in the logs much easier

# reset buffer to current log line
/^[0-9]{4}-[0-9]{2}-[0-9]{2}/ {
  print buffer
  buffer = $0
}

# line is continuation of previous statement, hold it for later
!/^[0-9]{4}-[0-9]{2}-[0-9]{2}/ {
  buffer = buffer " " $0
}

# print final statement
END {
  print buffer
}