2 ms·
> When I do a SELECT * in the shell, the default is a nicely formatted result that's easy for me to read. That's not my experience with Postgres. Both use pipe
by paulryanrogers 3y ago
> When I do a SELECT * in the shell, the default is a nicely formatted result that's easy for me to read. That's not my experience with Postgres.
Both use pipe-delimited tables with spaces for padding, no?
MySQL has \G for vertical (per query) and Psql has \x (toggle).
- spacedcowboy 3y agoThe last time I used Postgres (admittedly, installed by a colleague who was in charge of that project, so I'm not sure if she changed some option) I got one column per horizontal line ... Actually reading up on this, it looks like "\x on" was specified, possibly a default changed somewhere? I live in a world of 4K monitors, so I can pull a terminal very wide and see a lot of data at a glance, and this format didn't really mesh well with that. It's not a deal-breaker - mostly I connect via an API anyway, it's usually just debugging where I'm doing manual queries, but it's just one more niggle, and it might be something (in this case) to do with the database defaults.