58 results found
-
30 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 -
View RAISE NOTICE results
According to the PostgreSQL documentation, the RAISE statement can be used to report messages and raise errors. I would like to be able to see the results of a RAISE NOTICE statement in the OUTPUT panel in dbForge.
It will be a great help in the debugging of functions and complex code.
15 votes -
Database diagrams
Will database diagrams be available, as they are in other dbForge Studio for other DBMS ?
15 votes -
edit table
edit table like dbForge Studio for mysql
12 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 -
In Data Editor grid how to switch off converting DateTime values into a local computer DateTime format?
In the table I have a column of timestamptz type, actually with value in UTC, and dbForge studio displays the values of this column in timezone of my local computer +03.
However, for me is important to see the data exactly how it is stored in DB.9 votes -
Role Management
Only one feature is preventing me from purchasing a full license - role/login management, similar to the Security Manager feature in the MySQL version of the product.
7 votes -
foreign tables in database explorer
Could you show foreign tables in database explorer?
6 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 -
Change column type on Import
When importing data from CSV Studio detects column types, but no way to change mapping. For example, int isn't enough, I'd like to change type to bigint.
5 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 -
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 -
context menu on index, to be able to script create, alter, drop an existing index
context menu on index, to be able to script create, alter, drop an existing index
4 votes -
4 votes
-
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 14 votes -
Query Builder
A Query Builder is missing and it would be really useful for sql sheets.
4 votes -
Show upper level objects, e.g. tablespaces
When I connect to my PostgreSQL 11.5 database using the dbForge Studio for PostgreSQL, only the databases are shown in the Database Explorer. How can I view the upper level objects, e.g. tablespaces?
4 votes -
Show panel with result set if it was previosly hidden
If panel with result set was hidden it should be unhidden on the next query execution.
Otherwise it is unclear whether the query has been executed or not.
For comparison, SSMS behaves this way.See a gif: https://i.imgur.com/pN6rvXW.gif
Steps to reproduce:
- execute a query
- hide panel with result set by mouse click to its horizontal border
- execute a query againExpected: the panel with result set is shown.
Actual: the panel with result set remains hidden.If user executes any select-statement he usually wants to see a result set, doesn't he?
So I don't see any reason…3 votes
- Don't see your idea?