13 results found

1. dbForge Studio for PostgreSQL?

   Write please the program for PostgreSQL.

   193 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   completed  ·  42 comments  ·  Delete…  ·  Admin →

2. dbForge Schema Compare for PostgreSQL

   It wolud be a good idea to release a schema comparison tool for PostgreSQL.

   25 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   completed  ·  4 comments  ·  Delete…  ·  Admin →

3. Export to file

   Export to file csv, xlsx

   8 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   completed  ·  0 comments  ·  Delete…  ·  Admin →

4. Connect via SSH with private key

   Connect via SSH with private key

   5 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   completed  ·  0 comments  ·  Delete…  ·  Admin →

5. Import different formats

   Import CSV, MS Excel, MS Access formats.
   Similar to EMS PG SQL Manager studio.
   Having more advanced features will help managing data; I don't mind paying for it

   4 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   completed  ·  0 comments  ·  Delete…  ·  Admin →

6. Work with Postgres 10.1

   Just downloaded the current version (10.1) of postgresql for windows, tried to connect with the beta and it says:

   The version of the PostgreSQL server (Host: localhost Port: 5432) is not supported.Support is done for PostgreSql versions starting 8.3.

   Is this a bug or does it have a limit on the higher version? Doesn't make much sense...

   4 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   completed  ·  1 comment  ·  Delete…  ·  Admin →

7. I want to know which is the owner or creater

   In properties' box should appear the creater or owner

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   completed  ·  1 comment  ·  Delete…  ·  Admin →

8. SQL script output like Aginity Workbench

   This is Aginity output:
   /*
   Current path set to $user, public /
   / Start time 6/6/2024 1:07:30 PM, end time 6/6/2024 1:07:30 PM. /
   / Duration 0.0334243 sec. /
   CREATE TABLE #tbl (id INT, strn TEXT);
   / Start time 6/6/2024 1:07:30 PM, end time 6/6/2024 1:07:31 PM. /
   / Duration 0.3152067 sec. */

   INSERT INTO #tbl (id, strn) VALUES (1, 'abc');
   /* Records Affected: 1. */

   /* Start time 6/6/2024 1:07:31 PM, end time 6/6/2024 1:07:36 PM. /
   / Duration 5.4033747 sec. */

   UPDATE #tbl SET strn = 'qwe' WHERE id = 1;
   /* Records Affected: 1. */

   /* Start time 6/6/2024 1:07:36 PM, end time 6/6/2024 1:07:36 PM. /
   / Duration 0.0334896 sec. */

   TRUNCATE TABLE #tbl;
   /* Start time 6/6/2024 1:07:36 PM, end time 6/6/2024 1:07:36 PM. /
   / Duration 0.0342941 sec. */

   DROP TABLE #tbl;

   This is dbForge for PostgreSQL 3.1.839 output:
   DML succeeded [0.077s]
   1 row affected [0.111s]
   1 row affected [0.219s]
   DML succeeded [0.071s]
   Execute succeeded [0.066s]

   This is Aginity output:
   /*
   Current path set to $user, public /
   / Start time 6/6/2024 1:07:30 PM, end time 6/6/2024 1:07:30 PM. /
   / Duration 0.0334243 sec. /
   CREATE TABLE #tbl (id INT, strn TEXT);
   / Start time 6/6/2024 1:07:30 PM, end time 6/6/2024 1:07:31 PM. /
   / Duration 0.3152067 sec. */

   INSERT INTO #tbl (id, strn) VALUES (1, 'abc');
   /* Records Affected: 1. */

   /* Start time 6/6/2024 1:07:31 PM, end time 6/6/2024 1:07:36 PM. /
   / Duration 5.4033747 sec. */

   UPDATE #tbl SET strn = 'qwe' WHERE id = 1;
   /* Records Affected: 1. */

   /* Start… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   completed  ·  1 comment  ·  Delete…  ·  Admin →

9. datetime formatting bad！

   ex: Display is 2019-08-09 01:37:37,But I hose display is 2019-08-09 13:37:37

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Delete…  ·  Admin →
   completed  ·  AdminDevart (_, Devart) responded

   This can be setup in the ‘Data Editor → Formatting’ section of the ‘Options’ window (select ‘Tools → Options…’ from the main menu).

10. Support for getting the execution plan of a statement

    I haven't found this opportunity to get an execution plan for my queries

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    completed  ·  0 comments  ·  Delete…  ·  Admin →

11. Syntax highlight in function body and anonymous blocks

    Please support for syntax highlight in function body and anonymous blocks defintion (i.e. between $$).
    Even obsolescent pgAdmin3 has this feature.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    2 comments  ·  Delete…  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    You have to use $plpgsql$ or $sql$.

12. "unterminated dollar-quoted string" error when creating plpgsql function with an empty string as default parameter value

    dbForge Studio Express for PostgreSQL 1.0.410.
    PostgreSQL 10.3 on x8664-alt-linux-gnu, compiled by x8664-alt-linux-gcc (GCC) 5.3.1 20151207 (ALT Linux 5.3.1-alt3), 64-bit

    "Unterminated dollar-quoted string" error raises when creating plpgsql function with an empty string as default parameter value.

    Repro:

    execute this script in dbForge Studio:

    create or replace function dbo.test123
    (
    
    p text = ''
    )
    returns void
    as
    
    $$
    declare
    begin
    null;
    end;
    $$
    language plpgsql;

    output:

    ------ Execution started: Connection: SQL.sql ------

    Error (1,1): unterminated dollar-quoted string at or near "$$
    declare
    begin
    null"
    DML succeeded [0,005s]
    Error (12,1): unterminated dollar-quoted string at or near "$$
    language plpgsql"

    ------------ Done: SQL.sql -------------

    dbForge Studio Express for PostgreSQL 1.0.410.
    PostgreSQL 10.3 on x8664-alt-linux-gnu, compiled by x8664-alt-linux-gcc (GCC) 5.3.1 20151207 (ALT Linux 5.3.1-alt3), 64-bit

    "Unterminated dollar-quoted string" error raises when creating plpgsql function with an empty string as default parameter value.

    Repro:

    execute this script in dbForge Studio:

    create or replace function dbo.test123
    (
    
    p text = ''
    )
    returns void
    as
    
    $$
    declare
    begin
    null;
    end;
    $$
    language plpgsql;

    output:

    ------ Execution started: Connection: SQL.sql ------

    Error (1,1): unterminated dollar-quoted string at or near "$$
    declare
    begin
    null"
    DML succeeded [0,005s]
    Error (12,1): unterminated dollar-quoted string at or near "$$
    language… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    completed  ·  0 comments  ·  Delete…  ·  Admin →

13. UTF-8 support!

    Unicode text displaying as ???????.

    Software: dbForge Studio Express for PostgreSQL 1.0.410

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Delete…  ·  Admin →