Great, thanks!
Regards
Calle
On Thu, 13 Aug 2020 at 06:08, Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:
> Hi Calle,
>
> The feature is not implemented yet -
> https://redmine.postgresql.org/issues/3256.
>
> On Thu, Aug 13, 2020 at 4:59 AM Calle Hedberg
> wrote:
>
>> Hi
>>
>> I fi
Hi Calle,
The feature is not implemented yet -
https://redmine.postgresql.org/issues/3256.
On Thu, Aug 13, 2020 at 4:59 AM Calle Hedberg
wrote:
> Hi
>
> I find that a nice feature... But if I may ask a related question that
> baffles me: If I paste multiple queries into a window and then run a
Hi
I find that a nice feature... But if I may ask a related question that
baffles me: If I paste multiple queries into a window and then run all of
them, they all run BUT the output window only show the last sub-query
result.
Is there a configuration setting that will concatenate output when run
I see, thanks for the explanation. It's a strange feature then, since
I accidentally selected part of the query and was so puzzled at the
cryptic error message that followed. And having an error is actually
the best case scenario. I can see someone doing copy/paste operations
to/from this query edi
Jack,
It's fine as it is once you get used to it. For more involved or
complicated queries I use another tool that gives me the option to either:
"Run Script", which runs the entire query window
"Run Statement", which has the benefit of running the selected text OR (and
this is the part I really
I don’t know if it’s even a good idea to change that functionality. When I’m
working on performance issues, I very well may put a very complicated SQL
statement with several sub-selects in the window, and start with just one of
the sub-selects to see what it’s performance issues might be. So it’
That's not a bug, it's a *feature* !!
Seriously though, presently the query window in pgAdmin4 has two options:
If nothing is selected -> run the entire window
If something is selected -> run just what's selected.
That's how it's been since, well as long as I can recall. Unlike some
other tools,
If I enter a well formed SQL query into the Query Editor, but only
select a portion of the query with the mouse and try to run, pgAdmin
will try to run the selected portion as the query (and will fail most
of the time because of syntax error)
Is it possible to add a command line interface (CLI) to pgadmin4 to use
schema diff in scripts (like apgdiff)?
B.,
I hate to be the bearer of bad news, but in a nutshell no. As you write,
with both pgAdmin and postgreSQL installed on the same machine there is no
need to open any ports to access that particular postgreSQL instance.
Unfortunately unless the other application is also installed on that same
s
I think you are missing the point Andrzej, my pgadmin and postgresql do run
on the same server and there is no need to open up port 5432 externally or
even internally and block access to the external world via the firewall as
pgadmin is connected via the local socket. And I like to keep it that way
But pgAdmin runs at the same ports, so You need them to be opened.
You can set in pgconf allowed IP pool.
You can change default port no por postgresql
Maybe You can consider "hardware" solution: on Your gateway make in
firewall rule for specific IP address with port mapping/triggering
e.g. If Yo
Andrzej,
QGIS is just an example as I use it in combination with postgis in order to
work in mapping GIS elements.
With odbc I still need to open up the server ports to the outside world
which is what I want to avoid.
regards,
Bastiaan
On Wed, 12 Aug 2020 at 11:43, androxkentaki wrote:
> i don
i don't know what id Qgis and why You want to do it via pgAdmin...
But did You consider using ODBC connection and its driver?
śr., 12 sie 2020 o 08:58 bw napisał(a):
> Hi,
>
> As I do not like to open-up my postgresql port to the outside world and
> managing users via pgadmin is very user frien
14 matches
Mail list logo
