Re: Editing boolean table value from keyboard
Hi, On Wed, Nov 28, 2018 at 3:38 AM Cherio wrote: > When I right click on a table and select "View/Edit Data" I can edit > fields from keyboard with the exception of boolean fields. There seem to be > no key that could toggle boolean values. It is currently only possible by > using mouse. > > This breaks the flow a bit. My usual routine is to start with the first > field, type in the value then hit "Tab". It goes to the next field. Repeat. > For boolean fields however I have to go back and grab mouse. > > I think a key (e.g. "Space") should be assigned to scroll through > "true"/"false"/NULL via keyboard. > > Am I missing something and such a key or key combination is already > assigned or can be configured? > > Please log this issue @ https://redmine.postgresql.org/projects/pgadmin4 Thanks, Khushboo > Thanks! >
Re: pgAdmin4 lacks ability to specify NULL values in CSV export.
Hi, On Wed, Nov 28, 2018 at 2:31 AM richard coleman wrote: > Using the following version of pgAdmin4: > > Version > 3.5 > Copyright > Copyright 2013 - 2018, The pgAdmin Development Team > Python Version > 3.6.7 (default, Oct 22 2018, 11:32:17) [GCC 8.2.0] > Flask Version > 0.12.2 > Application Mode > Desktop > Current User > pgadm...@pgadmin.org > > It appears that pgAdmin4 lacks the ability to export the results of a > query containing NULL values as anything other than blank strings. This > makes it impossible to utilize those files to INSERT records into other > tables, especially if the field type is a non text value (i.e. Int, > Numeric, etc.). pgAdmin3 as well as competing products allow nulls to be > exported as NULL. Am I missing where this feature is, or can it be added > back to pgAdmin? > > Please log this issue @ https://redmine.postgresql.org/projects/pgadmin4 Thanks, Khushboo > Thanks, > > rik. >
Editing boolean table value from keyboard
When I right click on a table and select "View/Edit Data" I can edit fields from keyboard with the exception of boolean fields. There seem to be no key that could toggle boolean values. It is currently only possible by using mouse. This breaks the flow a bit. My usual routine is to start with the first field, type in the value then hit "Tab". It goes to the next field. Repeat. For boolean fields however I have to go back and grab mouse. I think a key (e.g. "Space") should be assigned to scroll through "true"/"false"/NULL via keyboard. Am I missing something and such a key or key combination is already assigned or can be configured? Thanks!
pgAdmin4 lacks ability to specify NULL values in CSV export.
Using the following version of pgAdmin4: Version 3.5 Copyright Copyright 2013 - 2018, The pgAdmin Development Team Python Version 3.6.7 (default, Oct 22 2018, 11:32:17) [GCC 8.2.0] Flask Version 0.12.2 Application Mode Desktop Current User pgadm...@pgadmin.org It appears that pgAdmin4 lacks the ability to export the results of a query containing NULL values as anything other than blank strings. This makes it impossible to utilize those files to INSERT records into other tables, especially if the field type is a non text value (i.e. Int, Numeric, etc.). pgAdmin3 as well as competing products allow nulls to be exported as NULL. Am I missing where this feature is, or can it be added back to pgAdmin? Thanks, rik.
RE: Problems connecting to remote database with recent pgAdmin versions
From: Calle Hedberg [mailto:calle.hedb...@gmail.com] Sent: Tuesday, November 27, 2018 6:52 AM To: pgadmin-support@lists.postgresql.org Subject: Problems connecting to remote database with recent pgAdmin versions Hi, I've been experiencing problems viewing tables and running scripts on a remote database (accessed using pgremote) with version 3.4 and 3.5 - I never had similar problems with earlier versions on the same remote server database. When e.g. selecting "view/edit last 100 records" for a table, or when opening a query tool window, I get a small red "disconnect" symbol but no error message of any kind. It is erratic, though - in periods everything works fine, then it starts failing again. During failure periods, I've also noticed that retrieving meta-data (properties, SQL) is very sluggish (but usually working, so the db IS connected) I suspect this is related to some change in a timeout configuration, but I don't know which and/or whether this behaviour need to be addressed through a pgadmin configuration setting or a configuration setting on the server side (the latter has not changed, but I obviously cannot rule out that there are changes in overall internet connectivity speed/bandwidth) Any thoughts on how to resolve this? Regards Calle What is “pgremote”? Igor Neyman
Problems connecting to remote database with recent pgAdmin versions
Hi, I've been experiencing problems viewing tables and running scripts on a remote database (accessed using pgremote) with version 3.4 and 3.5 - I never had similar problems with earlier versions on the same remote server database. When e.g. selecting "view/edit last 100 records" for a table, or when opening a query tool window, I get a small red "disconnect" symbol but no error message of any kind. It is erratic, though - in periods everything works fine, then it starts failing again. During failure periods, I've also noticed that retrieving meta-data (properties, SQL) is very sluggish (but usually working, so the db IS connected) I suspect this is related to some change in a timeout configuration, but I don't know which and/or whether this behaviour need to be addressed through a pgadmin configuration setting or a configuration setting on the server side (the latter has not changed, but I obviously cannot rule out that there are changes in overall internet connectivity speed/bandwidth) Any thoughts on how to resolve this? Regards Calle