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 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
On Wed, Nov 20, 2019 at 09:22:02AM -0500, Brian Dunavant wrote:
> On Wed, Nov 20, 2019 at 9:16 AM stan 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:
>
>
On Wed, Nov 20, 2019 at 9:16 AM stan 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 ''
Chances are those are all nulls, and will now display as whatever you
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.