Thread: Function for replace
Hi all,
In my database recently change backslash_quote to safe_enconding, now a need replace characters blocked to space or nothing.
I think create a function to scan every table in database, anybody make a similar work or have this made?
thanks
In my database recently change backslash_quote to safe_enconding, now a need replace characters blocked to space or nothing.
I think create a function to scan every table in database, anybody make a similar work or have this made?
thanks
__________________________________________________
Fale com seus amigos de graça com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/
On Thu, Aug 20, 2009 at 01:50:42PM -0700, paulo matadr wrote: > In my database recently change backslash_quote to safe_enconding, now > a need replace characters blocked to space or nothing. Why do you want to do that? Nothing is "blocked" now, it just changes the default format for literals that appear in your SQL code. Sam
----- Mensagem encaminhada ----
De: paulo matadr <saddoness@yahoo.com.br>
Para: Sam Mason <sam@samason.me.uk>
Enviadas: Quinta-feira, 20 de Agosto de 2009 21:57:29
Assunto: Res: [GENERAL] Function for replace
On Thu, Aug 20, 2009 at 01:50:42PM -0700, paulo matadr wrote:
> In my database recently change backslash_quote to safe_enconding, now
> a need replace characters blocked to space or nothing.
Why do you want to do that? Nothing is "blocked" now, it just changes
the default format for literals that appear in your SQL code.
Sam
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
De: paulo matadr <saddoness@yahoo.com.br>
Para: Sam Mason <sam@samason.me.uk>
Enviadas: Quinta-feira, 20 de Agosto de 2009 21:57:29
Assunto: Res: [GENERAL] Function for replace
because my application give error when try to reregister some features.
I have a many cases that use this feature
De: Sam Mason <sam@samason.me.uk>
Para: pgsql-general@postgresql.org
Enviadas: Quinta-feira, 20 de Agosto de 2009 18:09:03
Assunto: Re: [GENERAL] Function for replace
Para: pgsql-general@postgresql.org
Enviadas: Quinta-feira, 20 de Agosto de 2009 18:09:03
Assunto: Re: [GENERAL] Function for replace
On Thu, Aug 20, 2009 at 01:50:42PM -0700, paulo matadr wrote:
> In my database recently change backslash_quote to safe_enconding, now
> a need replace characters blocked to space or nothing.
Why do you want to do that? Nothing is "blocked" now, it just changes
the default format for literals that appear in your SQL code.
Sam
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 - Celebridades - Música - Esportes
Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 - Celebridades - Música - Esportes