Escape variable

From: Jaime Rivera <jriverarojas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Escape variable
Date: 2016-10-27 15:57:19
Message-ID: CAFP1Jqzw_jUZFimFM5L7wRqhEn_CgAU-rUFGvG-8fkVpBMXNBQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2016-10-27 16:10:50 Re: libpq heartbeat
Previous Message Francisco Olarte 2016-10-27 15:49:02 Re: libpq heartbeat