Postgres Pro
Downloads
Home   >   mailing lists

Re: Identical command-line command will not work with \i metacommand and filename - Mailing list pgsql-general

From Richard Huxton
Subject Re: Identical command-line command will not work with \i metacommand and filename
Date
Msg-id 4BCFFCD4.7010601@archonet.com
Whole thread Raw
In response to Re: Identical command-line command will not work with \i metacommand and filename  (John Gage <jsmgage@numericable.fr>)
Responses Re: Identical command-line command will not work with \i metacommand and filename  (John Gage <jsmgage@numericable.fr>)
Byte order mark added by (the envelope please...) pgAdmin3 !!  (John Gage <jsmgage@numericable.fr>)
List pgsql-general
Tree view 
On 22/04/10 08:24, John Gage wrote:
> Yeesh.  What the ding-dong is this?
>
> JohnGage:EFNWebsite johngage$ od -a CopySql.sql
> 0000000 ? ? ? s e l e c t sp * sp f r o m
> 0000020 sp m e s h _ d e s c r i p t o r
> 0000040 s ; nl nl
>
> What are the ?'s. Mon Dieu, what is going on?

http://en.wikipedia.org/wiki/Byte_order_mark

Tends to get added if you go through a Windows system. Useless for utf-8
afaik. Confuse the hell out of you because various tools parse and hide
them then you pipe the file to a script and everything falls over.

Bunch of scripts available here to remove them:
   http://www.xs4all.nl/~mechiel/projects/bomstrip/

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: installation on vista
Next
From: John Gage
Date:
Subject: Re: Identical command-line command will not work with \i metacommand and filename