On Thu, Feb 18, 2010 at 9:52 PM, Josh Berkus <j...@agliodbs.com> wrote: > On 2/18/10 1:20 PM, Dave Page wrote: >> On Thu, Feb 18, 2010 at 9:06 PM, Josh Berkus <j...@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.
Yup :-) -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
