Windows psql -f load of files with tabs changing to escape sequences

Поиск
Список
Период
Сортировка
От Doug Knight
Тема Windows psql -f load of files with tabs changing to escape sequences
Дата
Msg-id 1194980355.32307.13.camel@arc-dknightlx.wsicorp.com
обсуждение исходный текст
Ответы Re: Windows psql -f load of files with tabs changing to escape sequences  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-hackers
All,
I am having a problem loading functions from a text file into postgres on the Windows platform. If the source code stored in the file contains tabs, they get changed to \x09, which causes problems when the function is executed. As an example see attached, which preserves the tabs in the original input file, and shows a condensed version of the \df+ output. Is there a way to force postgres to load the file exactly as is? The command I used to load the function was similar to "psql -U postgres -d test -f func.sql" (func.sql was the name of the original file containing only the CREATE FUNCTION section).

Doug Knight
WSI Corp
Andover, MA USA

Вложения

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

Предыдущее
От: "Jignesh K. Shah"
Дата:
Сообщение: Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Windows psql -f load of files with tabs changing to escape sequences