Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

have you tried "\x on" and "\x auto" in psql?


yep. 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.


In 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.




Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: