Re: [GENERAL] Making NULLs visible. - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] Making NULLs visible.
Date
Msg-id 199810091636.MAA11892@candle.pha.pa.us
Whole thread Raw
In response to [GENERAL] Making NULLs visible.  (Stuart Rison <stuart@ludwig.ucl.ac.uk>)
Responses Re: [GENERAL] Making NULLs visible.
Re: [GENERAL] Making NULLs visible.
List pgsql-general
> Dear All,
>
> Is there a way to make postgreSQL 'show' nulls rather than have them appear
> as blank fields?
>
> code|name
> ----+----
> 5678|
> 8888|
> (2 rows)
>
> brecard5=> select * from test;
> code|name
> ----+------------------
> 1234|one two three four
> 5678|
> 9999|
> 8888|
> (4 rows)

I am always looking for suggestions on how to display nulls.  It is on
the TODO list.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


pgsql-general by date:

Previous
From: Stuart Rison
Date:
Subject: [GENERAL] Making NULLs visible.
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] How to drop entries in a table?