hmm, I was shelling out and using psql and piping the data to another
file. Not using the dbi stuff with perl.
Guess i can use a regular expression and review the link you sent me
and escape them my self.
Don't *ahem* quote me on this as I haven't been using Perl for a while
but it should
Chris Worley wrote:
...
For example, if I create a
table with a single bytea column called "foo" and insert the a record with
value "^F^O^O" then dump it, the dump will have the following:
COPY byteatest (foo) FROM stdin;
\\006\\017\\017
\.
How does pg_dump and pg_restonre handle everyth
On Tue, Apr 21, 2009 at 1:39 PM, Steve Crawford
wrote:
> Chris Worley wrote:
>>
>> Hello,
>>
>> I get the following error when running a sql script containing a COPY
>> command:
>>
>> ERROR: invalid byte sequence for encoding "UTF8": 0xff...
>>
>> The data I have contains binary data from a tcp d
Chris Worley wrote:
Hello,
I get the following error when running a sql script containing a COPY command:
ERROR: invalid byte sequence for encoding "UTF8": 0xff...
The data I have contains binary data from a tcp dump
Does anybody know how the dump pulls a column with binary data? It is
Hello,
I get the following error when running a sql script containing a COPY command:
ERROR: invalid byte sequence for encoding "UTF8": 0xff
HINT: This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".
What
