| Installation | |
| SQL
Editor/ Instant SQL View |
Major changes have been applied
to the Core that enables the SQL editor to analyze SQL syntax
while typing and annotate errors
in text or overview ruler. This feature is very nice but unfortunately
the SQL dialects out there are fairly different. Configuration of
datatypes and functions that are
considered by the analyzer will follow in a future release, for now you
can only disable analyzation if you do not like the syntax error
annotations.Completion has also been improved/bugfixed to support you with the full SQL dialect that is built in the code as well as any kind of database element (schemas, tables, columns, constraints, indizes). Another nice addition are query templates that you can freely configure using the SQL editor preference page. They
work nearly the same as you know it from the Java editor. In addition,
backstep positions that you define are recognized by the the completion
so that a select statement template as you see it in the screenshot can
be used to first choose a table or view to select from and then choose
the appropriate columns from these tables or views.Last but not least are Comment/Uncomment actions that you can use as usual when you select a block of text and hit Ctrl+Shift+/ or Ctrl+Shift+\. |
|
|
|
| Tables
View |
For connections the explicitly
choose a catalog in the URL, e.g. jdbc:postgresql://host:port/testdb
all catalogs were displayed in the past which has been changed. If you
want switch back to the old style you can choose Show all Catalogs from the view menu. |
|
|
|
