Re: BUG: pgAdmin III View table with empty strings - Mailing list pgadmin-support

From Dave Page
Subject Re: BUG: pgAdmin III View table with empty strings
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B844B309@mail.vale-housing.co.uk
Whole thread Raw
In response to BUG: pgAdmin III View table with empty strings  ("Matej Rizman" <matej.rizman@guest.arnes.si>)
List pgadmin-support

> -----Original Message-----
> From: Matej Rizman [mailto:matej.rizman@guest.arnes.si]
> Sent: 16 July 2003 00:34
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] BUG: pgAdmin III View table with
> empty strings
>
>
> Version: 0.8.0 (Jul 14 2003), Win32 version
>
> Steps:
> 1) create table with one varchar column
> CREATE TABLE public.test
> (
>   a varchar(50) NOT NULL
> ) WITHOUT OIDS;
>
> 2) fill it with some empty strings
> INSERT INTO test(a) VALUES('')
>
> 3) run pgAdmin III, select table and choose view data from popup menu
>
> 4) pgAdmin III shows two apostrophes ('') instead of empty strings.

Hi,

That is by design and is described in the new docs/en_US/editgrid.html
file. The two single quotes represents empty string, whereas an empty
box represents NULL.

Regards, Dave.


pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: FW: pgAdmin3: adding comments to existing tables
Next
From: "Dave Page"
Date:
Subject: Re: minor bug in pgAdmin3 when creating views