string fields helps

Поиск
Список
Период
Сортировка
От marcelo Cortez
Тема string fields helps
Дата
Msg-id 94617.80409.qm@web32104.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: string fields helps
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Christan Josefsson"
Дата:
Сообщение: Advanced query rewrite
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Dynamic DDL