| From: | John Lynn <mr(dot)john(dot)lynn(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Reading a file on Windows with psql |
| Date: | 2009-11-09 15:23:54 |
| Message-ID: | c45c1f380911090723j23df13d2v9a4e252bcc2ea04f@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Windows (Windows Server 2008), I create a file using a tool (Data
Generator for PostgreSQL), and then try to execute the script using:
psql --file="C:\PDS\TestData\populate_companies.sql" --dbname=tst --username=tst
I get an error, pointing to the first character in the file. So I open
the file using pgAdmin and I see only an "I" (the first character of
the first command in the file, which is an INSERT) in the file.
If I load the file into a Windows editor, I see that it's a "unicode"
file. If I re-save it as a "DOS" file, then psql is able to read it.
Is there a way to convince psql to read a file in "unicode" format?
PostgreSQL is 8.4.. Thanks for your help!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-11-09 15:29:38 | Re: Reading a file on Windows with psql |
| Previous Message | Michael Lush | 2009-11-09 09:58:44 | Re: FATAL: the database system is starting up |