It wolud be a good idea to release a schema comparison tool for PostgreSQL.13 votes
Would like the context menu when you right click on the table to have CREATE Script, SELECT Script, INSERT Script, etc just like pgAdmin 3 does, but for the insert and update generation provide the option for named parameters instead of positional ?, ? which pgAdmin does.9 votes
Objects tree on the left hand side should group objects:
- by schema (ex. first node in the tree: Public, next: X, etc)
- by type: tables, views, triggers, functions, etc6 votes
When we retrieve the data, if we have any json/jsonb column, when we edit, we see edit box shown as text view mode. It should be automatically select jsonView as default based on field type.
Note: Latest express edition used.4 votes
Will database diagrams be available, as they are in other dbForge Studio for other DBMS ?3 votes
MySQL Workbench have feature to create a model without requiring an actual database. We can create/update/remove objects. Please make this one. dbForge studio for MySQL DBD is totally opposite. It requires to have a database (connection) and any changes done reflects to actual db. :(
This is the reason I prefer MySQL workbench to create DB diagrams.2 votes
JSONB, JSON column => as JSON
INT,DECIMAL => as NUMERIC
At moment, we have to switch type eveytime, this is so annonying.2 votes
Copy as SQL2 votes
BEGIN / COMMIT / ROLLBACK is ignored when pressing "Execute Current Statement". Button / menu item for transaction control do not exists.
Changing auto-commit mode are helpful, too:
- auto-commit on
- auto-commit off => preserve error state
- auto-commit off with auto rollback
- auto-commit off with auto save point and rollback (emulates other dbs)1 vote
Cached data changes in grid view like in dbForge Studio for Oracle is missing here.
Hope the feature will be ported to this tool, too.1 vote
Like Visual Studio, It would be great to keep files organized in project structure e.g. stored procs, functions, scripts, etc.1 vote
We should be able to dump whole table, schema or database using dump tool in PostgreSQL.1 vote
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.1 vote
I haven't found this opportunity to get an execution plan for my queries1 vote
Please please please add a geometry data type map viewer. Please have a configurable basemap that accepts vector tile maps and allows for both free and paid sources (eg Carto and Mapbox)1 vote
Could you show foreign tables in database explorer?1 vote
Possible to add a feature of JSON/JSONB value auto-completion?
It would be a great feature to have that no one has.
P.S. Same goes for XML column type1 vote
1. Ctrl+Space to show custom function / procedures in intellisense.
2. Ctrl+Space to show user created views in intellisense.
3. 'column'::<list> -> Show list of supportted types
and so on...1 vote
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
SELECT "column" FROM table;
-- OR --
SELECT 'column' FROM table;
Currently it just replaces the selected text with quote:
SELECT ' FROM table;1 vote
- Don't see your idea?