The OP mentions gui, but what is the best gui/code editor/ide for postgres for linux?
I found this list. I'll go through them.
https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...
I found this list. I'll go through them.
https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...
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.
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.
You can get part of the way there by Sublime Text to run queries and browse results. In Sublime, it's easy - you can create a custom "build tool" with (essentially) just one line of config... you're basically just piping the current file's contents to command-line PSQL: https://www.youtube.com/watch?v=tPd4m3PLVqU
Then I use the SublimeAllAutocomplete package. It works just like "regular" Sublime autocomplete except it gives you autocomplete suggestions from all open files, not just the current one - so if you have your DB schema dump in another window it will use that: https://github.com/alienhard/SublimeAllAutocomplete
Obviously, that doesn't really give you the smartest autocomplete ever but it's pretty productive for me. Tons of room for improvement though.