Thread: Escape Quotes

Escape Quotes

From
Nicholas Walker
Date:
Is there anyway to disable the escape quotes in stored procedures.

For example..you write a function that as variable=''something''; and pgadmin modifies that to be
variable=\'something\';  It makes stored procedure quoting a pain to look at.
 

Thanks,
Nicholas Walker


Re: Escape Quotes

From
Andreas Pflug
Date:
Nicholas Walker wrote:
> Is there anyway to disable the escape quotes in stored procedures.
> 
> For example..you write a function that as variable=''something'';
>  and pgadmin modifies that to be variable=\'something\';
>    It makes stored procedure quoting a pain to look at.

The function property editor will let you edit the function without 
double quoted or escaped strings.

Regards,
Andreas