Add a new table format that resembles postgres psql.

Amjith Ramanujam · Amjith Ramanujam · commit eb212e4d6e15 · 2014-11-28T10:33:35.000-08:00
diff --git a/README.rst b/README.rst
@@ -181,6 +181,17 @@ extensions::
     │ bacon  │     0 │
     ╘════════╧═══════╛
 
+``psql`` is like tables formatted by Postgres' psql cli::
+
+    >>> print tabulate.tabulate()
+    +--------+-------+
+    | item   |   qty |
+    |--------+-------|
+    | spam   |    42 |
+    | eggs   |   451 |
+    | bacon  |     0 |
+    +--------+-------+
+
 ``pipe`` follows the conventions of `PHP Markdown Extra`_ extension.  It
 corresponds to ``pipe_tables`` in Pandoc. This format uses colons to
 indicate column alignment::
diff --git a/tabulate.py b/tabulate.py
@@ -197,6 +197,14 @@ def escape_char(c):
                               headerrow=DataRow("|", "|", "|"),
                               datarow=DataRow("|", "|", "|"),
                               padding=1, with_header_hide=None),
+                  "psql":
+                  TableFormat(lineabove=Line("+", "-", "+", "+"),
+                              linebelowheader=Line("|", "-", "+", "|"),
+                              linebetweenrows=None,
+                              linebelow=Line("+", "-", "+", "+"),
+                              headerrow=DataRow("|", "|", "|"),
+                              datarow=DataRow("|", "|", "|"),
+                              padding=1, with_header_hide=None),
                   "rst":
                   TableFormat(lineabove=Line("", "=", "  ", ""),
                               linebelowheader=Line("", "=", "  ", ""),
