Re: Making "invisible" characters visible ? (psql)

On Wed, Nov 20, 2019 at 09:22:02AM -0500, Brian Dunavant wrote:
> On Wed, Nov 20, 2019 at 9:16 AM stan <stanb(at)panix(dot)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.

Thank you for your help.

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin