Обсуждение: Escape Quotes

Поиск
Список
Период
Сортировка

Escape Quotes

От
Nicholas Walker
Дата:
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

От
Andreas Pflug
Дата:
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