77 results found
-
lowercase
Add an option in autocompletion and SQL formatter that makes all reserved words lowercase. I know that PostgreSQL prefers uppercase, but I use several languages and have the own code style. Moreover, using too may caps seems a liitle bit weird.
1 vote -
Show row counts in tooltip when you hover over a table name in editor
Would love to see this feature that is currently in dbForge SQLComplete for SSMS in dbForge Studio for Postgres.
See the difference in this screenshot:
https://imgur.com/a/arJ3RWLIn SSMS (left), when you hover over a table name in editor, the tooltip shows the estimated row count in table as the last line, below the table description/comments.
2 votes -
Duplicate current line with Ctrl+D
When in the editor in dbForge Studio for Postgres, placing the caret in a line and hitting the Ctrl+D key combination should duplicate the current line the caret is in, below the current line. Multiple text editors provide this key combo for this purpose.
Here is a GIF showing this functionality in Notepad++
https://imgur.com/a/hHjCRSe1 vote -
Focus caret in Search box when Query History is opened with Ctrl+Alt+H
The Query History window can be opened at any time in dbForge Studio for Postgres with the Ctrl+Alt+H key combo, but when the window opens, the caret does not position itself in the "Search" text box. It take an extra mouse click to position the caret in the Search box before you can start typing your search term.
Here is a GIF showing this:
https://imgur.com/a/qgr6SfCIt would be nice if caret is auto-positioned in the Search box when the Query History window opens so you can start typing immediately.
1 vote -
F12 function key pressed on an object name in editor should select object in Database Explorer
Would love to see the F12 function key behavior from dbForge SqlComplete in SSMS added to dbForge Studio for Postgres.
Here is a GIF of how the F12 key works in SSMS:
https://imgur.com/a/LZCOE7kWhen in the editor, you can place the caret on a object name (table, column, etc.) and hit F12, and the Database Explorer panel on the left expands to select that object.
1 vote -
Add feature to highlight matches when typing
I suggest to add highlighting matches when typing a text in (Ctrl+F)-window.
Here is how it works in SSMS:
https://i.imgur.com/DXypWLj.gifIt is especially useful when using regular expressions so that you see all highlighted matches of a pattern in text immediatelly.
1 vote -
Enhance suggestion for 'drop database' statement
When user is typing 'drop database' statement, the application should add "with(", but not "with".
It helps to type this command faster.Now user must add "(" and ")" by himself.
Here is an example:
https://i.imgur.com/t1jerz2.gif1 vote -
Show panel with result set if it was previosly hidden
If panel with result set was hidden it should be unhidden on the next query execution.
Otherwise it is unclear whether the query has been executed or not.
For comparison, SSMS behaves this way.See a gif: https://i.imgur.com/pN6rvXW.gif
Steps to reproduce:
- execute a query
- hide panel with result set by mouse click to its horizontal border
- execute a query againExpected: the panel with result set is shown.
Actual: the panel with result set remains hidden.If user executes any select-statement he usually wants to see a result set, doesn't he?
So I don't see any reason…2 votes -
Allow @ For Named Parameters
We use Telerik Reports for our report viewer. We'd like to use dbForge Studio for PostgreSQL to do our SQL development. Telerik uses '@' for named parameters, but dbForge Studio allows only ':'. This makes it a pain to move SQL code between the two applications. Please allow @ for named parameters.
1 vote -
context menu
context menu on table trigger to script (create or replace) trigger function directly
1 vote -
context menu on index, to be able to script create, alter, drop an existing index
context menu on index, to be able to script create, alter, drop an existing index
3 votes -
Schema Compare include indexes
On Schema Comparison should be nice compare all the information of a table, indexes was part of that.
3 votes -
LIVE RAISE NOTICE MESSAGES
I see that the RAISE NOTICE in postgresql does print out, but you can't see them until after the query has completed. Most other IDEs print out the notices while the query is running. This is actually quite useful when debugging long running queries. I, like most developers, will add RAISE NOTICE to print out running times, and if a query takes a long time I may cancel the query half way through but already have several messages printed for what I have changed and can see if I have made any progress without having to wait for the entire…
1 vote -
Detect file encoding automatically when opening files
Our project files are UTF-8 encoded. Our various text editors detect this automatically - VS Code, for example - but dbForge asks for the encoding when opening and defaults to "Western European (Windows)". The result is any UTF-8 specific characters are corrupted without warning.
If this code is applied to a database the database code will also be corrupted without warning.
I would suggest attempting to detect the file encoding automatically and only ask for the file encoding if the detection fails.
2 votes -
3 votes
-
When support for PostgreSQL 14.x version is planned?
We are using currently PostgreSQL 13.6. Due to some new features we need to migrate to PostgreSQL 14. Is support for PostgreSQL version 14 planned and when?
3 votes -
Reload Files Changed Outside IDE
I sometimes change my SQL files outside of dbForge (e.g. inside Visual Studio when making minor changes before commit to git). I would like dbForge to ask me to reload changed files when I switch back to the dbForge window (or do so automatically if the file hasn't also changed in dbForge). Pretty much all editors support this feature - it baffles me that dbForge doesn't...or am I missing something?
2 votes -
change names on property's box
Will be easy can change or rename the columns or tables
1 vote -
Highlight error between $$
All text between $$ (anonymous or named i.e. $name$) code highlighted as text literal. E.g. standard example from official PG docs:
CREATE PROCEDURE insert_data(a integer, b integer)
LANGUAGE SQL
AS $$
INSERT INTO tbl VALUES (a);
INSERT INTO tbl VALUES (b);
$$;All text from $$ to $$ is colored as literal.
2 votes -
Add "Administration" tab in dbForge Studio for PostgreSQL
Can you please add, in dbForge Studio for PostgreSQL, an "Administration" tab similar to Oracle and MySQL versions: * Monitor Sessions * Manage Server Security (database users management) * Some maintenance stuff and so on ?
3 votes
- Don't see your idea?