Search Postgresql Archives

string fields helps

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Folks  

  I need to save data on rtf format but , postgres   
refuses to storage for backslah or character's 
problem's   any idea or vice are welcomed       best
regards 
 mdc

pd: sample off data to save ( from postgres log)

"
 UPDATE plbrecord SET documentation =
'{\rtf1\ansi\deff0{\fonttbl{\f0\fnil Tahoma;}}
        \viewkind4\uc1\pard\lang1033\f0\fs16
        \par }
        ', version_ = 4 WHERE (plbrecord.id_ = 8 AND
plbrecord.version_ = 3 AND plbrecord.inst_class_ =
'EntityDataWindow')
LOG:  statement: COMMIT1
LOG:  statement: BEGIN
LOG:  statement: UPDATE plbrecord SET documentation =
'{\rtf1\ansi\deff0{\fonttbl{\f0\fnil Tahoma;}}
        \viewkind4\uc1\pard\lang1033\f0\fs16   SELECT
"PARAMETROS"."PARAMETRO",
        \par  
substr(to_char("PARAMETROS"."F_VAL_PARAM",
''YYYY/MM/DD''), 1,10),
        \par  
substr(to_char("PARAMETROS"."F_ANUL_PARAM",''YYYY/MM/DD''),
1,10),
        \par          "PARAMETROS"."VALOR1",
        \par          "PARAMETROS"."VALOR2"
        \par     FROM "PARAMETROS"
        \par " )
        \par
        \par }
        ', version_ = 5 WHERE (plbrecord.id_ = 8 AND
plbrecord.version_ = 4 AND plbrecord.inst_class_ =
'EntityDataWindow')
LOG:  statement: COMMIT
LOG:  statement: BEGIN
LOG:  statement: UPDATE plbrecord SET documentation =
'{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0
Tahoma;}{\f1\fnil Tahoma;}}
        \viewkind4\uc1\pard\lang1033\f0\fs18   SELECT
"PARAMETROS"."PARAMETRO",
        \par  
substr(to_char("PARAMETROS"."F_VAL_PARAM",
''YYYY/MM/DD''), 1,10),
        \par  
substr(to_char("PARAMETROS"."F_ANUL_PARAM",''YYYY/MM/DD''),
1,10),
        \par          "PARAMETROS"."VALOR1",
        \par          "PARAMETROS"."VALOR2"
        \par     FROM "PARAMETROS"
        \par " )
        \par \f1\fs16
        \par }
"


      __________________________________________________ 
Preguntá. Respondé. Descubrí. 
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta). 
¡Probalo ya! 
http://www.yahoo.com.ar/respuestas 



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux