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

From: Doug Knight <dknight(at)wsi(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Windows psql -f load of files with tabs changing to escape sequences
Date: 2007-11-13 18:59:15
Message-ID: 1194980355.32307.13.camel@arc-dknightlx.wsicorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
example.txt text/plain 653 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-11-13 19:09:57 Re: Windows psql -f load of files with tabs changing to escape sequences
Previous Message Gregory Stark 2007-11-13 18:57:49 Re: [HACKERS] pgsql: Use strip -x on OS/X-darwinbecause non-"-x" causes link