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

58 results found

  1. Only Database objects are display in the DE, Roles would be handy.

    4 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. 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

    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. A Query Builder is missing and it would be really useful for sql sheets.

    4 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)
  4. 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

    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. dbForge Studio analyses all tables, primary keys, relations and creates diagram automatically.

    4 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. 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

    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)
  7. 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

    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)
  8. 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

    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. 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)
  10. 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)
  11. There are a couple of things that I wish I can get straight out of the IDE and they are served via extensions at the moment which would be great if they were exposed as functionalities for postgreSQL installations that have the extensions installed:

    1- Integration with pgplslql_check to show issues in function (If the current linter implementation is not going to be expanded upon), this will show errors or warning as you type or at function creation / alter time.

    2- pgstatstatements & pgstatkcache so you can have the monitoring stats for queries and other…

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

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

    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

    under review  ·  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)
  14. 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.gif

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

    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)
  16. context menu on table trigger to script (create or replace) trigger function directly

    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)
  17. Will be easy can change or rename the columns or tables

    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

    planned  ·  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)
  18. All text between $$ (anonymous or named i.e. $name$) code highlighted as text literal. E.g. standard example from official PG docs:

    CREATE PROCEDURE insert_data(a integer, b integer)
    LANGUAGE SQL
    AS $$
    INSERT INTO tbl VALUES (a);
    INSERT INTO tbl VALUES (b);
    $$;

    All text from $$ to $$ is colored as literal.

    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

    started  ·  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. It would be great to be able to enter Proxy Server Credential to update software in corporate environment

    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. It flickers above it. 100Hz and below seems to be ok

    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)
  • Don't see your idea?