Re: Garbage character inserted at the beginning of every SQL file on OSX

On 2/18/10 1:20 PM, Dave Page wrote:
> On Thu, Feb 18, 2010 at 9:06 PM, Josh Berkus <josh@agliodbs.com> wrote:
>> On 2/17/10 2:52 PM, Josh Berkus wrote:
>>>> It's not garbage, it's a Unicode BOM.
>>>>
>>>> If your other software cannot read Unicode files properly, you can
>>>> turn off Unicode file writing under File -> Options.
>>> psql is apparently unhappy with the BOM.
>>>
>>> Thanks, I'll let you know if that fixes the issue; if it does, that
>>> should go in the FAQ.
>> This appears to fix the problem.  I suggest the following FAQ item:
>>
>> Q: Why do I get "Error On Line 1" trying to load SQL files created with
>> pgAdmin using psql or other command-line tools?
>>
>> A: The command-line tools you are using are not unicode-friendly, or are
>> not configured to be.  You should turn off Unicode in the pgAdmin
>> preferences for the Editor.
> 
> Inclusion on the FAQ would imply that this is a frequently asked
> question - which it most certainly isn't.

Well, now it's in the list archives at least.

--Josh Berkus