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@panix.com> 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@aklaver.com