-
Menu "Set Value to" with Boolean
Hi! Would be great for multiple selection.
1 vote -
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 11 vote -
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
1 vote -
Filter for schemas and tables (using names and wildcards) during Schema Comparing
Product: dbForge Schema Compare for PostgreSQL
Product Version: 1.1.1
Schema filtering is important, because some schemas include temporary and internal data. For example in many extension (timescaledb, pg_partman).
Some time developer want to include these schema, some time does not.1 vote -
one instance
Hallo,
es wäre super, wenn man DB-Forge optional nur einmal starten könnte. Leider habe ich oft mehrere Instanzen gestartet. Die geöffneten/gespeicherten Tabs sind dann unterschiedlich.
1 vote -
Permit the SQL results as text vs grid to be set both before and after a query
Permit the SQL results as text vs grid to be set both before and after a query. Sometimes once a query is run, it's useful to be able to convert it to text without running the query again.
1 vote -
Query execution on a timed interval
The ability to execute a query repeatedly base on a time interval - a refresh rate if you will.
1 vote -
Fix correspondence of sort order for stacked bar chart and its legend
Check the correspondence between a pivot table / stacked bar chart's legend sort order and the sort order of the bar stack. Its wrong- read the bar from base to top and the legend reads from top to bottom, they should be inverted to be WYSIWYG.
1 vote -
to support selection of multiple tables or sequences for deleting a group of them.
This was the reason why I downloaded the trial since pgAdmin did not allow that either.
1 vote -
1 vote
-
Link Features in "What’s New in dbForge" to Page in Documentation
Hi!
Please make a link of the Features in "What’s New in dbForge" to Page in Documentation
so one can find what exactly is die Feature.
For Example "Generate Script AS CREATE" in v2.2: cant find in Documentation what /where exactly i can use it.Greetings, Marc
1 vote -
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)1 vote -
cached update in data grid
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 -
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 -
Auto-complete for custom functions/views/procedures/type casting etc...
- Ctrl+Space to show custom function / procedures in intellisense.
- Ctrl+Space to show user created views in intellisense.
- 'column'::<list> -> Show list of supportted types
and so on...
1 vote -
Data generation from tables with foreign keys.
Add the ability for Data generation from tables with foreign keys.
1 vote -
How do we import csv file into psql from azure storage account?
Usually using copy command we can import files into psql stored in local drive. How can we use copy command to import files stored in azure storage account?
1 voteAdminDevart (_, Devart) responded
You can download the file to a local drive and perform data import.
Also, you can import it using ODBC https://docs.devart.com/studio-for-postgresql/exporting-and-importing-data/migrating-data-from-other-servers.html
-
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 -
0 votes
- Don't see your idea?