I hate to nitpick over style, but for the purposes of use Database Administrators is there a way to clean this up a bit,
SELECT 1 AS "myCol1", 2 AS "myCol2";
+--------+--------+
| myCol1 | myCol2 |
+--------+--------+
| 1 | 2 |
+--------+--------+
For comparison, with PostgreSQL,
SELECT 1 AS "myCol1", 2 AS "myCol2";
myCol1 | myCol2
--------+--------
1 | 2
Can I get the psql output from MySQL or MariaDB?
I know `psql, the client for PostgreSQL has a ton of options for formatting the output table
\C
Sets the title of any tables being printed as the result of a query or unset any such title. This command is equivalent to \pset title title. (The name of this command derives from “caption”, as it was previously only used to set the caption in an HTML table.)\a
If the current table output format is unaligned, it is switched to aligned. If it is not unaligned, it is set to unaligned. This command is kept for backwards compatibility. See \pset for a more general solution.\pset
,border
columns
expanded
fieldsep
fieldsep_zero
footer
format
(supportshtml
,asciidoc
,latex
,latex-longtable
, andtroff-ms
)linestyle
null
numericlocale
recordsep
recordsep_zero
tableattr
title
tuples_only
unicode_border_linestyle
,unicode_column_linestyle
,unicode_header_linestyle
- and on, and on.