59 results found
-
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 -
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 -
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 -
1 vote
-
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 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 -
foreign tables in database explorer
Could you show foreign tables in database explorer?
6 votes -
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 -
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 -
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 -
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 -
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 -
Database diagrams
Will database diagrams be available, as they are in other dbForge Studio for other DBMS ?
15 votes -
copy
Copy as SQL
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 -
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.
25 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 -
30 votes
- Don't see your idea?