psql backslash command support?
I saw this mentioned as being supported but when I try to use any of them it gives a syntax error. So what is supported?
Also, is it possible to have the tool introspect all databases on a server? It's annoying to have to constantly change the connection properties to each specific database in order to have them listed. Would much prefer having an object browser implementation like MS SSMS, where it shows you all available databases when you connect to a server.
Please sign in to leave a comment.
1. I provided your feedback into the issue: https://youtrack.jetbrains.com/issue/DBE-1272
2. Do you mean PostgreSQL? Then follow: https://youtrack.jetbrains.com/issue/DBE-2287
I was banging my head against the wall trying to figure out why my script files were not working. I just assumed that if support was provided for a given database, it would use the native dialect of that given database. The tool validates backslash commands as valid, but then fails on execute. So I am not sure what this means.
I was hoping to use this as a tool to work with my database scripts. I guess I can use it as an editor, but I can't really execute them from within the environment because of this limitation. I am hoping I am missing something.
I don't even see a way to open a terminal in order to run the files manually. I must be missing something.
To run terminal: Ctrl+Shift+A → Terminal
backslash commands stuff is better to write in the issue with the screenshot.
I was running this through DataGrip
DataGrip 2016.3
Build #DB-163.7744.4, built on November 18, 2016
JRE: 1.8.0_112-release-408-b2 x86_64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
And Ctrl+Shift+A does not provide a terminal, nor do I see it under [View | Tool Windows]
However, If I open up my directory with my sql files as an intellij project I get the functionality I need. I get nice file management, editing, source control, and all the database tools. It even appears to validate the postgres script properly. So I launch an interactive psql session in the terminal (available in intellij) and everything is good. It would be nice to run these commands through the db interface/tools. This would be a welcomed addition.