From: | Peter Belbin <pbelbin(at)broadsoft(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | pgAdmin4: how to set row value to NULL using query data output pane? |
Date: | 2016-10-12 22:33:28 |
Message-ID: | db681d6c-19bb-87ea-4995-074c5c344e47@broadsoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Oscar | 2016-10-13 06:53:04 | SQL window bracket control |
Previous Message | Terry Schmitt | 2016-10-12 14:57:25 | Re: Server status report in PGAdmin 4 |