73 results found
-
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 -
Ability to generate table scripts
Ability to generate table scripts Select, Select First N, Insert, Update, Delete
3 votes -
More detailed insert/update/delete errors
For example: In pgAdmin I ran an insert statement and was told exactly what value was causing the foreign key constrain error. In dbForge I'm not told what value is causing the error.
pgAdmin Error:
ERROR: insert or update on table "return" violates foreign key constraint "FKreturncategorycategoryid"
DETAIL: Key (category_id)=(Lodging) is not present in table "category".
SQL state: 23503dbForge Error:
1 insert or update on table "return" violates foreign key constraint "FKreturncategorycategoryid" SQL.sql 1 13 votes -
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 -
Autocomplete SQL after JOIN definition (pgAdmin4 4.x can do it)
Autocomplete SQL after JOIN definition (pgAdmin4 4.x can do it)
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 -
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
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 -
2 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 -
I want to know which is the owner or creater
In properties' box should appear the creater or owner
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 -
Allow stacking query results in the same tab like in SSMS
You used to support this for mysql.
It is unbelievably annoying to have to run comparison queries in separate tabs, then copy and paste the data into another program in order to do simple comparisons.
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 -
Command execution keyboard shortcuts
Execute selected or current sql block with CTRL-Enter or CTRL-E.
2 votes
- Don't see your idea?