58 results found
-
Session browser
A screen similar to Toad or DBeaver which show active sessions, allows grouping, sorting, filtering. Provides runtime information from pgstatactivity. Allows auto-refresh. For example:
postgres 9119 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 (null) (null) active
tagmanager 13679 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
tagmanager 13316 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
rdsadmin 26264 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
maxnote 23469 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
maxnote 23470 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
tagmanager 13317 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
maxnote 24322 xxxxx 2020-10-05…3 votes -
Show upper level objects, e.g. tablespaces
When I connect to my PostgreSQL 11.5 database using the dbForge Studio for PostgreSQL, only the databases are shown in the Database Explorer. How can I view the upper level objects, e.g. tablespaces?
3 votes -
Automatically create diagram for database
dbForge Studio analyses all tables, primary keys, relations and creates diagram automatically.
3 votes -
Automatic Quote insertion
SELECT column FROM table;
When I select the column name or any text and press Single or Double quote key, The column name should be surrounded by that quote:
SELECT [column] FROM table; -- [column] => selected text
Exptected:
SELECT "column" FROM table;
-- OR --
SELECT 'column' FROM table;
Currently it just replaces the selected text with quote:
SELECT ' FROM table;3 votes -
Automatice detect DataType and show view
JSONB, JSON column => as JSON
INT,DECIMAL => as NUMERIC
so on...At moment, we have to switch type eveytime, this is so annonying.
3 votes -
copy
Copy as SQL
3 votes -
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 -
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 -
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 -
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 -
Copy or cut line in one keystroke like in Visual Studio
"if you just want to cut or copy one line, you don't have to select the line. All you have to do is put your cursor on the line and press Control+X or Control+C. Visual Studio will cut or copy the whole line, including the carriage return."
https://visualstudiomagazine.com/Blogs/Tool-Tracker/2015/02/Cut-Copy-One-Keystroke.aspx
2 votes -
Add Roles to the Database Explorer
Only Database objects are display in the DE, Roles would be handy.
2 votes -
Link Features in "What’s New in dbForge" to Page in Documentation
Hi!
Please make a link of the Features in "What’s New in dbForge" to Page in Documentation
so one can find what exactly is die Feature.
For Example "Generate Script AS CREATE" in v2.2: cant find in Documentation what /where exactly i can use it.Greetings, Marc
2 votes -
Ability to see all views / tables / materialized views under one node of Object Explorer
Is there a way to see all views / tables / materialized views in the object explorer together, without separating them by type?
2 votes -
Application to create snapshot files of remote databases
Application to create small snapshot of remote databases to be downloaded and compared to master database where a new script is generated to run on remote machine.
2 votes -
Add support for the \include filename meta-command
psql supports \include and \include-relative meta commands that allow one script to be called from another.
Please include this functionality in dbForge.
2 votes -
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 -
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
- Don't see your idea?