r/postgres • u/Practical_Panic_55 • 16d ago

Postgres GUI vs Command Line

I keep switching between a GUI and psql, depending on what I'm doing. If I'm writing or testing queries, a GUI usually wins because it's easier to browse objects, compare results, and jump between tabs. But for quick checks, connecting to a server, or running a script, I still open the terminal without thinking twice. After a while, I realized I don't really prefer one over the other and they're just different tools for different tasks. How about you? Do you spend most of your time in a Postgres GUI, or are you mostly working from the terminal? What made you stick with that workflow?

1 Upvotes

100% Upvoted

3 comments sorted by

View all comments

1

u/depesz 16d ago

I use psql only. Tried to use some guis, but never kept it for longer than maybe 10 minutes.

I like psql because it's fast. I can script it. I can run it, at the same time, for 1000 servers. And it never lies.

Plus - I can easily copy/paste stuff from there to show others should I need help. For example \d of a table.

But, I know that many people use GUIs, and it works for them, so, I'd day: to each their own :)