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
pgadmin4(at)pgadmin(dot)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.