Le 04/12/2010 02:45, Josh Berkus a écrit :
>
>> 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.
>
It goes away because the file is no longer in UTF-8, and that may not be
what the OP wants.
I have a patch ready to be commited that will handle this. But you will
need next pgAdmin's release.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com