I'm trying to switch from pgAdmin to DataGrip for managing my postgres databases and I can't find some basic things:
First, I'd like to see messages coming from RAISE NOTICE etc. inside functions. Is there a panel for that? I don't see anything until a function completes executing. Tried looking at Output window, Database event log, General event log - nothing there.
Second, I can't see a timer while running a query, so I can't really tell how long the query is taking until it's finished. That's very handy in pgAdmin, but I can't find it anywhere in DataGrip. Is there an option for that?
Third, I don't completely understand the difference between database consoles and files. I can run a query in a database console, but I can't run it from a file in the same way. When I hit run in a file, DataGrip offers me to run my query in a new or existing console. How can I run queries directly from files without spawning new consoles, or cluttering existing ones? My workflow is quite simple - I keep all my .sql files in a git repo folder and just want to both edit and run queries direclty from files.