Thread: Inconsistent display of NULL and empty string values
Hello, I have a usability problem with pgAdmin, namely it displays certain values in different ways depending on a part of the application. Here is a screenshot of the problem: http://i.imgur.com/xrEYt.jpg NULL values are shown as <NULL> in the query editor, but as empty cells in the data editor. Empty strings are shown as empty cells in the query editor, but they are double apostrophes in the data one. This issue makes it hard to check data in the tables, because you constantly have to remind yourself how the data is represented in each view. I'm working on pgAdmin III v1.16 x32 (installed with binary of PostgreSQL 9.2.1), English language, on Windows 7 x64. Regards, Arkadiusz Piekarz
On 08/10/2012 17:55, Arkadiusz Piekarz wrote: > Hello, > I have a usability problem with pgAdmin, namely it displays certain > values in different ways depending on a part of the application. > Here is a screenshot of the problem: http://i.imgur.com/xrEYt.jpg > > NULL values are shown as <NULL> in the query editor, but as empty > cells in the data editor. > Empty strings are shown as empty cells in the query editor, but they > are double apostrophes in the data one. > > This issue makes it hard to check data in the tables, because you > constantly have to remind yourself how the data is represented in each > view. +1 to the above - if it's possible, I'd also like to see consistency across all of PgAdmin on the display of nulls in particular. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
On Mon, 2012-10-08 at 18:03 +0100, Raymond O'Donnell wrote: > On 08/10/2012 17:55, Arkadiusz Piekarz wrote: > > Hello, > > I have a usability problem with pgAdmin, namely it displays certain > > values in different ways depending on a part of the application. > > Here is a screenshot of the problem: http://i.imgur.com/xrEYt.jpg > > > > NULL values are shown as <NULL> in the query editor, but as empty > > cells in the data editor. > > Empty strings are shown as empty cells in the query editor, but they > > are double apostrophes in the data one. > > > > This issue makes it hard to check data in the tables, because you > > constantly have to remind yourself how the data is represented in each > > view. > > +1 to the above - if it's possible, I'd also like to see consistency > across all of PgAdmin on the display of nulls in particular. > Seems fair. I added a ticket to remember to work on this later. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com