pgAdmin4 lacks ability to specify NULL values in CSV export.

From: richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com>
To: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: pgAdmin4 lacks ability to specify NULL values in CSV export.
Date: 2018-11-27 21:00:56
Message-ID: CAGA3vBsiDKT8Q3A1PQ_8D1Dg5CNu3crwaOTi7mh9c3YxnrAupA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Cherio 2018-11-27 22:08:06 Editing boolean table value from keyboard
Previous Message Igor Neyman 2018-11-27 19:13:51 RE: Problems connecting to remote database with recent pgAdmin versions