On Mon, Sep 03, 2007 at 01:36:58PM +0530, Ashish Karalkar wrote: > Hello All, > > I have a data script which runs fine from PgAdmin SQL Editor,but when I run this from command prompt I get following error: > test=# \i /usr/local/pgsql/qsweb1/QSWEB_100_4_Default_Data.sql > > psql:/usr/local/pgsql/qsweb1/QSWEB_100_4_Default_Data.sql:1: ERROR: invalid byt > e sequence for encoding "UTF8": 0xff > HINT: This error can also happen if the byte sequence does not match the encodi > ng expected by the server, which is controlled by "client_encoding". Well, the error is correct, that's not a valid UTF-8 character. I seem to remember someone saying that ooasionally windows puts BOMs in UTF-8 files (which is completely bogus). Check the file using a simple text editor a check if there are some odd characters at the beginning of the file. Have a ncie day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
