Re: [pgadmin-support] syntax error for no apparent reason - Mailing list pgsql-admin

From Josh Berkus
Subject Re: [pgadmin-support] syntax error for no apparent reason
Date
Msg-id 4CF99D40.90306@agliodbs.com
Whole thread Raw
In response to syntax error for no apparent reason  (Willy-Bas Loos <willybas@gmail.com>)
Responses Re: [pgadmin-support] syntax error for no apparent reason  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-admin
> I've encountered this before, psql gives me a syntax error for no clear
> reason. It's allways on the first character of a sql file.
> I think that there must be some strange character code at the first
> position, maybe it is because i share a ntfs partition with the windows
> installation on my laptop and move files around.

Yeah, this is caused by pgadmin adding a unicode marker at the first
position of the file.  If you uncheck "Read and Write Unicode UTF-8
Files" in the preferences, this issue should go away.


--
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com

pgsql-admin by date:

Previous
From: Willy-Bas Loos
Date:
Subject: syntax error for no apparent reason
Next
From: Guillaume Lelarge
Date:
Subject: Re: [pgadmin-support] syntax error for no apparent reason