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


Reply via email to