Thread: pgAdmin4 lacks ability to specify NULL values in CSV export.
Using the following version of pgAdmin4:
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?
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
Thanks,
rik.
Hi,
On Wed, Nov 28, 2018 at 2:31 AM richard coleman <rcoleman.ascentgl@gmail.com> wrote:
Using the following version of pgAdmin4:Version3.5CopyrightCopyright 2013 - 2018, The pgAdmin Development TeamPython Version3.6.7 (default, Oct 22 2018, 11:32:17) [GCC 8.2.0]Flask Version0.12.2It 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?Application ModeDesktop
Please log this issue @ https://redmine.postgresql.org/projects/pgadmin4
Thanks,
Khushboo
Thanks,rik.