70 results found
-
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 -
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 -
Schema Compare include indexes
On Schema Comparison should be nice compare all the information of a table, indexes was part of that.
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
-
I want to know which is the owner or creater
In properties' box should appear the creater or owner
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 ?
2 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 12 votes -
Add Roles to the Database Explorer
Only Database objects are display in the DE, Roles would be handy.
2 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…2 votes -
Command execution keyboard shortcuts
Execute selected or current sql block with CTRL-Enter or CTRL-E.
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 -
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;2 votes -
Linux / Mac version
Most developers works under mac / linux, wish to use your software on linux
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 -
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?