| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | stan <stanb(at)panix(dot)com>, Brian Dunavant <dunavant(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Making "invisible" characters visible ? (psql) |
| Date: | 2019-11-20 15:18:46 |
| Message-ID: | 50972395-714a-84a6-7629-568f57d5ec00@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(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.
NULL is a value so it should 'show' up.
>
> Thank you for your help.
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2019-11-20 15:20:08 | Re: Return Table in StoredProceure/Function |
| Previous Message | Pavel Stehule | 2019-11-20 15:08:13 | Re: Return Table in StoredProceure/Function |