Postgres Client

This is a really good app. I must say that I wasn't expecting much from this app but it's better than I expected. This app allowed me to connect to my test PostgreSQL database and manipulate the data at will. The reason why I left it 4 stars is because when I created my first connection, I used the server host name rather than the server IP address. When I went to change the connection settings I couldn't change the host address, so I had to delete the connection and start over again.

Nice, but only one active SQL query means it's not that useful. e.g. if you're writing a statement and need to check a column name in the schema, it's not possible as it's done though a second SQL query, so you lose the one you're working on.

Same query is running on navicat in windows but giving 'syntax query error' in this app...any idea how to fix this. Issue is if first statement is not select then it is giving error, in my query I'm using 'set interval=....' statement as a first statement and it is giving error, even if we keep first line as comment still gives the same 'syntax query error' Query: with tab_name as ( select current_date) Select * from tab_name