Formats a list of dictionaries as a fancy psqlish-style table.

pppretty.py

def ppprint(data, fields=None, precision=2):
    """
        P-P-PRETTY PRINTER!
        >>> ppprint([{"foo": 1.2, "bar": "beer"}, {"foo": "bazzzzz", "bar": "bad"}])
    """
    if fields is None:
        fields = list(data[0].keys())
    
    formatted_fields = []

    for row in data:
        for field in fields:
            if isinstance(row[field], float):
                row[field] = '%.2f' % row[field]

    widths = [
        max(
            [len(field)] + [len(str(row[field])) for row in data]
        )
        for field in fields
    ]

    row_str = ' ' + ' | '.join('{:>%s}' % width for width in widths)

    result = row_str.format(*fields) + '\n'
    result += '+'.join(('-' * (width + 2)) for width in widths) + '\n'
    result += '\n'.join(
        row_str.format(*cell) for cell in [[row[field] for field in fields] for row in data]
    )

    print(result)

    
if __name__ == '__main__':
    ppprint([
        {"foo": 1.2, "bar": "beer"},
        {"foo": "bazzzzz", "bar": "bad"}
    ])