Making "invisible" characters visible ? (psql)

From: stan <stanb(at)panix(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Making "invisible" characters visible ? (psql)
Date: 2019-11-20 14:16:32
Message-ID: 20191120141632.GA16560@panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I added a column to an existing table, so there should be nothing (actually
the default, I suppose) in this column for all existing rows.

However if I do:

select new_column from modified_table ;

I get the total number of rows in the table, but the lines on the screen
have no visible characters. I was expecting these to be nulls, and this
select to return nothing.

How can i make these "invisible" characters visible?

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Dunavant 2019-11-20 14:22:02 Re: Making "invisible" characters visible ? (psql)
Previous Message Enrico Pirozzi 2019-11-20 14:16:00 Foreign keys and locks.