Postgres Pro
Downloads
Home   >   mailing lists

Thread: NULL vs empty string in Query Tool

NULL vs empty string in Query Tool

From
Chris Reigrut
Date:
Is there any way to distinguish between an empty string ('') and a NULL 
string value in the query tool?

Re: NULL vs empty string in Query Tool

From
"George Pavlov"
Date:
Chris Reigrut wrote:
> Is there any way to distinguish between an empty string ('') and a
NULL
> string value in the query tool?

I'd like to resurrect this question from a while ago. It does not seem
like it got any response. It would be great if pgAdmin's Query Tool had
a setting similar to psql's "\pset NULL" formatting option. It is very
easy to confuse the two and most query tools that I know of allow for
that.

George

Re: NULL vs empty string in Query Tool

From
Andreas Pflug
Date:
George Pavlov wrote:

>Chris Reigrut wrote:
>  
>
>>Is there any way to distinguish between an empty string ('') and a
>>    
>>
>NULL 
>  
>
>>string value in the query tool?
>>    
>>
>
>I'd like to resurrect this question from a while ago. It does not seem
>like it got any response. It would be great if pgAdmin's Query Tool had
>a setting similar to psql's "\pset NULL" formatting option. It is very
>easy to confuse the two and most query tools that I know of allow for
>that.
>

Still on the list, as the original mail.

Regards,
Andreas