From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Garbage character inserted at the beginning of every SQL file on OSX |
Date: | 2010-02-18 21:53:25 |
Message-ID: | 937d27e11002181353lca6447ve3e7e86767d0fafc@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Thu, Feb 18, 2010 at 9:52 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> On 2/18/10 1:20 PM, Dave Page wrote:
>> On Thu, Feb 18, 2010 at 9:06 PM, Josh Berkus <josh(at)agliodbs(dot)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.
Yup :-)
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Mario Splivalo | 2010-02-21 12:48:56 | Graphical Query Builder - usage stats? |
Previous Message | Josh Berkus | 2010-02-18 21:52:45 | Re: Garbage character inserted at the beginning of every SQL file on OSX |