3 ms·
I've gone through that list before, but never find anything compelling enough to pull me away from psql (the built-in CLI client). I highly recommend learning
by smilliken 12y ago
I've gone through that list before, but never find anything compelling enough to pull me away from psql (the built-in CLI client).
I highly recommend learning psql first. It doesn't have every feature you might want, but it gets the basics right and is easy to integrate with your editor and other tools. As far as I can tell, it's what most professionals use.
- yangyang 12y agoI fully agree with this. I used pgAdmin for a while but have recently switched to psql and it's much more useful. In particular, learn the \ commands. It's extremely useful to be able to quickly look at the structure of a table, dump the source to a function and so on, from a command prompt rather than navigating trees with the mouse in pgAdmin. It uses readline where available so you get history, completion etc.