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
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 |