| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | John Gage <jsmgage(at)numericable(dot)fr> |
| Cc: | Dave Page <dpage(at)pgadmin(dot)org>, Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>, pgAdmin Support List <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] Byte order mark added by (the envelope please...) pgAdmin3 !! |
| Date: | 2010-04-22 10:12:24 |
| Message-ID: | r2n9837222c1004220312lfb5a6023l4eed953cc5040858@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
On Thu, Apr 22, 2010 at 12:02, John Gage <jsmgage(at)numericable(dot)fr> wrote:
> I think I should clarify my original "problem" and what I see as the
> difficulty in general.
>
> I saved a UTF-8 file with the pgAdmin Query tool, which added the BOM to the
> beginning of the file during the save.
>
> I then attempted to run the file using psql with the \i meta command.
>
> I got a syntax error pointing at the very beginning of the file which turned
> out to be on account of the BOM.
>
> In other words, files saved with pgAdmin3 Query tool cannot then be run as
> files of SQL commands by psql.
>
> The two applications are incompatible at that level.
FYI, psql in PostgreSQL 9.0 will ignore UTF8 BOMs.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yodan Tauber | 2010-04-22 10:21:44 | Re: BUG #5404: Mirrored pgadmin GUI |
| Previous Message | John Gage | 2010-04-22 10:02:18 | Re: [GENERAL] Byte order mark added by (the envelope please...) pgAdmin3 !! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Gage | 2010-04-22 10:29:12 | Re: [GENERAL] Byte order mark added by (the envelope please...) pgAdmin3 !! |
| Previous Message | Peter Geoghegan | 2010-04-22 10:11:48 | Re: Getting the typename of a polymorphic function's magical $0 variable |