Re: UTF8 with BOM support in psql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: UTF8 with BOM support in psql
Date
Msg-id 28242.1256053891@sss.pgh.pa.us
Whole thread Raw
In response to Re: UTF8 with BOM support in psql  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: UTF8 with BOM support in psql
Re: UTF8 with BOM support in psql
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> What I think we might sensibly do is to eat the leading BOM of an SQL 
> file iff the client encoding is UTF8, and otherwise treat it as just 
> bytes in whatever the encoding is.

That seems relatively non-risky.

> Should we also do the same for files passed via \copy? What about 
> streams on stdin? What about files read from the backend via COPY?

Not thrilled about doing this on stdin --- you have no good
justification for assuming that start of stdin corresponds to a file
boundary somewhere.  COPY files, maybe.
        regards, tom lane


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Could postgres be much cleaner if a future release skipped backward compatibility?
Next
From: Merlin Moncure
Date:
Subject: Re: Controlling changes in plpgsql variable resolution