string fields helps

From: marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: string fields helps
Date: 2007-04-16 22:04:54
Message-ID: 94617.80409.qm@web32104.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-04-16 22:24:25 Re: Dynamic DDL
Previous Message Christan Josefsson 2007-04-16 21:42:40 Advanced query rewrite