Windows psql -f load of files with tabs changing to escape sequences - Mailing list pgsql-hackers

From Doug Knight
Subject Windows psql -f load of files with tabs changing to escape sequences
Date
Msg-id 1194980355.32307.13.camel@arc-dknightlx.wsicorp.com
Whole thread Raw
Responses Re: Windows psql -f load of files with tabs changing to escape sequences  (Martijn van Oosterhout <kleptog@svana.org>)
List 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

Attachment

pgsql-hackers by date:

Previous
From: "Jignesh K. Shah"
Date:
Subject: Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Windows psql -f load of files with tabs changing to escape sequences