Skip site navigation (1) Skip section navigation (2)

Reading a file on Windows with psql

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: (view raw, whole thread or download thread mbox)
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!


pgsql-novice by date

Next:From: Tom LaneDate: 2009-11-09 15:29:38
Subject: Re: Reading a file on Windows with psql
Previous:From: Michael LushDate: 2009-11-09 09:58:44
Subject: Re: FATAL: the database system is starting up

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group