4 ms·
I've always found MySQL's CLI vastly easier to use than PostgreSQL. The \G command alone is godsend. And the ASCII formatting makes everything much more reada
by deckard1 11y ago
I've always found MySQL's CLI vastly easier to use than PostgreSQL. The \G command alone is godsend. And the ASCII formatting makes everything much more readable to me.
- postila 11y agohave you tried "\x on" and "\x auto" in psql?
- agopaul 11y agoIn MySQL you append \G at the end of the query instead of ; to get the same result as \x. Weird I know, but it works. Still psql is a superior client IMHO.
- deckard1 11y agoyep. It's not the same at all. The format is harder to read, and the point of \G is you can do it without toggling. Say you run a query. Turns out, you need vertical format to see the entire contents. Just hit up arrow, replace the ';' at the end with '\G' and run the query again. MySQL also has \c which I find tremendously useful, when you screw something up mid-query.