Hi! Would be great for multiple selection.1 vote
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.
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: 23503
1 insert or update on table "return" violates foreign key constraint "FKreturncategorycategoryid" SQL.sql 1 11 vote
"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."1 vote
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
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. Sometimes once a query is run, it's useful to be able to convert it to text without running the query again.1 vote
The ability to execute a query repeatedly base on a time interval - a refresh rate if you will.1 vote
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
This was the reason why I downloaded the trial since pgAdmin did not allow that either.1 vote
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, Marc1 vote
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
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
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
- 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
Add the ability for Data generation from tables with foreign keys.1 vote
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
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?