On 11/20/19 7:01 AM, stan wrote:
On Wed, Nov 20, 2019 at 09:22:02AM -0500, Brian Dunavant wrote:
On Wed, Nov 20, 2019 at 9:16 AM stan <stanb@xxxxxxxxx> wrote:
How can i make these "invisible" characters visible?
In psql, by default it displays nulls as nothing. You can specify what
they should display as with:
\pset null '<something>'
Chances are those are all nulls, and will now display as whatever you set
them to. If they aren't, let us know.
That worked, and yes they are NULLs, guess I expected to get 0 rows, as the
only column I requested contained ONLY NULL's.
basic misunderstanding on my part, i suppose.
NULL is a value so it should 'show' up.
Thank you for your help.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
