pgAdmin4: how to set row value to NULL using query data output pane? - Mailing list pgadmin-support

From Peter Belbin
Subject pgAdmin4: how to set row value to NULL using query data output pane?
Date
Msg-id db681d6c-19bb-87ea-4995-074c5c344e47@broadsoft.com
Whole thread Raw
List pgadmin-support
I'm using pgAdmin 4 version 1.0 (release) on Apple Mac, Macos 10.12 
(sierra).

I have used the 'view data' of the last 100 rows, and have the Query 
pane with the Data Output sub-pane showing.

I double-click on a column / row instance, and up comes a dialog box.  I 
remove the value that's shown, and hit 'save', then, click on the 'save' 
icon at the top of the query pane in order to persist the change.

in this case, the column happens to be a timestamp, with nulls allowed.

the complaint shows up indicating that it appears to be trying to set 
the value to be an empty string rather than a null.

how is this done please?

Of course, I know how to do this using sql, but, shouldn't I be able to 
do this via the graphical gui too?

thank you!
peter



-- 


This email is intended solely for the person or entity to which it is 
addressed and may contain confidential and/or privileged information. If 
you are not the intended recipient and have received this email in error, 
please notify BroadSoft, Inc. immediately by replying to this message, and 
destroy all copies of this message, along with any attachment, prior to 
reading, distributing or copying it.



pgadmin-support by date:

Previous
From: Laczkóczki Ákos
Date:
Subject: Re: Cannot launch pgAdmin4
Next
From: Johann Spies
Date:
Subject: Problem createing table with citext