13 results found
-
dbForge Studio for PostgreSQL?
Write please the program for PostgreSQL.
193 votes -
dbForge Schema Compare for PostgreSQL
It wolud be a good idea to release a schema comparison tool for PostgreSQL.
25 votes -
Export to file
Export to file csv, xlsx
8 votes -
Connect via SSH with private key
Connect via SSH with private key
5 votes -
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 it4 votes -
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 -
I want to know which is the owner or creater
In properties' box should appear the creater or owner
2 votes -
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…
1 vote -
datetime formatting bad!
ex: Display is 2019-08-09 01:37:37,But I hose display is 2019-08-09 13:37:37
1 voteThis can be setup in the ‘Data Editor → Formatting’ section of the ‘Options’ window (select ‘Tools → Options…’ from the main menu).
-
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 -
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 voteYou have to use $plpgsql$ or $sql$.
-
"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…1 vote -
UTF-8 support!
Unicode text displaying as ???????.
Software: dbForge Studio Express for PostgreSQL 1.0.410
1 vote
- Don't see your idea?