confused about backslashes

Поиск
Список
Период
Сортировка
От Frank Morton
Тема confused about backslashes
Дата
Msg-id 00ae01bddb32$2ea0f4b0$8355e5ce@tesla.base2inc.com
обсуждение исходный текст
Ответы Re: [INTERFACES] confused about backslashes  (Peter T Mount <peter@retep.org.uk>)
Список pgsql-interfaces
can someone help me out here.

I want to put the real text data of "\\QM_RIP1\HEIDEL41"
in a text field.

If I put double backslashes representing one backslash
in an insert statement as in "\\\\QM_RIP1\\HEIDEL41"
and then do a select on that field with psql, I actually see
the double backslashes (unexpected). But, if i do a query
using JDBC, it does correctly revert to the single backslash
I originally was after. I still don't follow this, but it works, so
I could just ignore it.

However, then i I do a dump of the database with "pg_dump -d",
this same field comes back out with single backslashes, which
if you pipe as input to psql to reload, the field is missing the
backslashes again.

Could someone explain this to me.




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

Предыдущее
От: Sferacarta Software
Дата:
Сообщение: Re[2]: [INTERFACES] Re: DELETE FROM TABLE doesn't work (AGAIN)
Следующее
От: David Hartwig
Дата:
Сообщение: Re: [INTERFACES] Re: DELETE FROM TABLE doesn't work (AGAIN)