60 results found
-
Add support for Projects
Like Visual Studio, It would be great to keep files organized in project structure e.g. stored procs, functions, scripts, etc.
5 votes -
Automatically create diagram for database
dbForge Studio analyses all tables, primary keys, relations and creates diagram automatically.
3 votes -
Dump PostgreSQL using pgdump or pg_dumpall
We should be able to dump whole table, schema or database using dump tool in PostgreSQL.
5 votes -
Would like the context menu when you right click on the table to have
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.
26 votes -
Transaction controls and settings
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)2 votes -
30 votes
-
Database diagrams
Will database diagrams be available, as they are in other dbForge Studio for other DBMS ?
15 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 -
foreign tables in database explorer
Could you show foreign tables in database explorer?
6 votes -
1 vote
-
Database Diagram without Database
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.
5 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 -
In objects tree, group objects by schema and type
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, etc11 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 -
set json view as default for json(b) fields.
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.
6 votes -
copy
Copy as SQL
3 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 -
add a map viewer
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 -
JSON/JSONB values auto-complete
Possible to add a feature of JSON/JSONB value auto-completion?
"column"->[show auto-complete-list]
"column"->'key'->[show auto-complete-list]It would be a great feature to have that no one has.
P.S. Same goes for XML column type
1 vote -
automatic quote TABLE and COLUMN names from suggestion and autocomplete feature
Because postgresql usually need to quote table and columns names (if names are not LOWERCASE), will be nice if sql editor, when suggesting for autocomplete, type "table name" or "column name" with also quotes.
1 vote
- Don't see your idea?