62 results found
-
Add "Administration" tab in dbForge Studio for PostgreSQL
Can you please add, in dbForge Studio for PostgreSQL, an "Administration" tab similar to Oracle and MySQL versions: * Monitor Sessions * Manage Server Security (database users management) * Some maintenance stuff and so on ?
4 votes -
Add Roles to the Database Explorer
Only Database objects are display in the DE, Roles would be handy.
4 votes -
Session browser
A screen similar to Toad or DBeaver which show active sessions, allows grouping, sorting, filtering. Provides runtime information from pgstatactivity. Allows auto-refresh. For example:
postgres 9119 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 (null) (null) active
tagmanager 13679 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
tagmanager 13316 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
rdsadmin 26264 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
maxnote 23469 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
maxnote 23470 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
tagmanager 13317 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
maxnote 24322 xxxxx 2020-10-05…4 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 -
Automatically create diagram for database
dbForge Studio analyses all tables, primary keys, relations and creates diagram automatically.
4 votes -
LIVE RAISE NOTICE MESSAGES
I see that the RAISE NOTICE in postgresql does print out, but you can't see them until after the query has completed. Most other IDEs print out the notices while the query is running. This is actually quite useful when debugging long running queries. I, like most developers, will add RAISE NOTICE to print out running times, and if a query takes a long time I may cancel the query half way through but already have several messages printed for what I have changed and can see if I have made any progress without having to wait for the entire…
3 votes -
Allow stacking query results in the same tab like in SSMS
You used to support this for mysql.
It is unbelievably annoying to have to run comparison queries in separate tabs, then copy and paste the data into another program in order to do simple comparisons.
3 votes -
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
3 votes -
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.3 votes -
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
3 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 -
copy
Copy as SQL
3 votes -
False positive syntax highligh errors
Please fix these false positive syntax errors in dbForge Studio 2025.1.186 with PostgreSQL 15:
-- false positive syntax error on alias "dec" for type "decimal"
create temp table tmp (id int, d dec(18,2));-- false positive syntax error on "nulls not distinct"
create index tmp_1 on tmp (id) nulls not distinct;-- false positive syntax error on "with ties"
select * from tmp order by id fetch first 10 rows only with ties;-- false positive syntax error on "fetch first" with variable
do $plpgsql$
declare _rows int = 1; _result int;
begin
select id into _result from tmp order…2 votes -
Create a Portable version of dbForge Studio
Our company does not grant us the admin privileges needed to install or update programs on our computers. I would love to have a 'portable' option where the program is installed in our user folders and does not require 'elevation' (admin privileges) to run.
2 votes -
merge into...
if i use MERGE INTO material.stock_serials AS target
USING (format doens't work
2 votes -
Enhance suggestion for 'drop database' statement
When user is typing 'drop database' statement, the application should add "with(", but not "with".
It helps to type this command faster.Now user must add "(" and ")" by himself.
Here is an example:
https://i.imgur.com/t1jerz2.gif2 votes -
Allow @ For Named Parameters
We use Telerik Reports for our report viewer. We'd like to use dbForge Studio for PostgreSQL to do our SQL development. Telerik uses '@' for named parameters, but dbForge Studio allows only ':'. This makes it a pain to move SQL code between the two applications. Please allow @ for named parameters.
2 votes -
context menu
context menu on table trigger to script (create or replace) trigger function directly
2 votes
- Don't see your idea?