| From: | Dave Page <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | Andreas Laggner <andreas(dot)laggner(at)vti(dot)bund(dot)de> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: sql-files with control characters at the beginning |
| Date: | 2010-02-24 15:00:46 |
| Message-ID: | 937d27e11002240700m555babcv8f1b856a186e8f36@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
On Wed, Feb 24, 2010 at 2:50 PM, Andreas Laggner
<andreas(dot)laggner(at)vti(dot)bund(dot)de> wrote:
> Hi List,
>
> i want to execute my sql-files, written with pgadmin 1.10.0 (from
> binaries for openSuse 11.2 64bit) directly on the server via nohup. But
> since 1.10 (i never had that problem in 1.08) the sql-file saved by
> pgadmin begins with 3 control characters. I can only see these
> characters, if i open the sql-file with mc and go to edit hexadecimal -
> i can replace these three by 20 20 20 (three space) and then i can run
> the sql-file, otherwise psql returns: syntax error at or near <feff>.
> This occurs on openSuse 11.2 64bit and on openSuse 11.1 64bit. Why puts
> pgadmin thiese three characters to my files??
See http://archives.postgresql.org/pgadmin-support/2010-02/msg00097.php
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2010-02-24 18:16:30 | Feature Request: change size of text in query result grid |
| Previous Message | Andreas Laggner | 2010-02-24 14:50:51 | sql-files with control characters at the beginning |