Skip to content

dbForge Studio for PostgreSQL

dbForge Studio for PostgreSQL is a GUI tool for managing and developing databases and objects. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to your requirements in a convenient and user-friendly interface. The tool provides a data editing tool to customize your queries and property window so that users can view all the required information of PostgreSQL database objects they are interested in.

https://www.devart.com/dbforge/postgresql/studio/

dbForge Studio for PostgreSQL

Categories

JUMP TO ANOTHER FORUM

70 results found

  1. 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?

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Autocomplete SQL after JOIN definition (pgAdmin4 4.x can do it)

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. dbForge Studio analyses all tables, primary keys, relations and creates diagram automatically.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. Copy as SQL

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. On Schema Comparison should be nice compare all the information of a table, indexes was part of that.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Our project files are UTF-8 encoded. Our various text editors detect this automatically - VS Code, for example - but dbForge asks for the encoding when opening and defaults to "Western European (Windows)". The result is any UTF-8 specific characters are corrupted without warning.

    If this code is applied to a database the database code will also be corrupted without warning.

    I would suggest attempting to detect the file encoding automatically and only ask for the file encoding if the detection fails.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. In properties' box should appear the creater or owner

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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 ?

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. 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: 23503

    dbForge Error:
    1 insert or update on table "return" violates foreign key constraint "FKreturncategorycategoryid" SQL.sql 1 1

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. Only Database objects are display in the DE, Roles would be handy.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. 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…

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. Execute selected or current sql block with CTRL-Enter or CTRL-E.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Is there a way to see all views / tables / materialized views in the object explorer together, without separating them by type?

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. 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;

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Most developers works under mac / linux, wish to use your software on linux

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. 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.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?