Thread: Escape variable
Hello,
I've been looking for a way to escape a variable inside a plpgsql stored procedure just like E works with constants.
For example :
select E'Se recibi\u00f3 a \n ci\u00f3n.'
Returns:
Se recibió a
ción.
Thanks
Jaime
On 10/27/2016 08:57 AM, Jaime Rivera wrote: > Hello, > > I've been looking for a way to escape a variable inside a plpgsql stored > procedure just like E works with constants. > > For example : > > * select E'Se recibi\u00f3 a \n ci\u00f3n.' * > > Returns: > > /*Se recibió a */ > /* ción.*/ Something like?: DO $$ DECLARE esc_str varchar; BEGIN esc_str = E'Se recibi\u00f3 a \n ci\u00f3n.' ; RAISE NOTICE '%', esc_str; END; $$ LANGUAGE plpgsql; NOTICE: Se recibió a ción. DO If not then can you show an example from in plpgsql? > > Thanks > > Jaime > > > -- Adrian Klaver adrian.klaver@aklaver.com