Re: [HACKERS] "COPY FROM" recognize \xDD sequence - addition to

2002-10-17 Thread Bruce Momjian
Gavin Sherry wrote: > On Wed, 16 Oct 2002, Tom Lane wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > Right now we assume \XXX is octal. We could support \x as hex because > > > \x isn't any special backslash character. However, no one has ever > > > asked for this. Does anyone else

Re: [HACKERS] "COPY FROM" recognize \xDD sequence - addition to

2002-10-16 Thread Gavin Sherry
On Wed, 16 Oct 2002, Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Right now we assume \XXX is octal. We could support \x as hex because > > \x isn't any special backslash character. However, no one has ever > > asked for this. Does anyone else think this would be benficial?

Re: [HACKERS] "COPY FROM" recognize \xDD sequence - addition to copy.c

2002-10-16 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Right now we assume \XXX is octal. We could support \x as hex because > > \x isn't any special backslash character. However, no one has ever > > asked for this. Does anyone else think this would be benficial? > > Well, it seems pr

Re: [HACKERS] "COPY FROM" recognize \xDD sequence - addition to copy.c

2002-10-16 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Right now we assume \XXX is octal. We could support \x as hex because > \x isn't any special backslash character. However, no one has ever > asked for this. Does anyone else think this would be benficial? Well, it seems pretty localized and harmless.

Re: [HACKERS] "COPY FROM" recognize \xDD sequence - addition to copy.c

2002-10-16 Thread Bruce Momjian
Right now we assume \XXX is octal. We could support \x as hex because \x isn't any special backslash character. However, no one has ever asked for this. Does anyone else think this would be benficial? --- Igor Georgiev w

[HACKERS] "COPY FROM" recognize \xDD sequence - addition to copy.c & idea 4 developers

2002-10-16 Thread Igor Georgiev
1. Why i do this:     I try to migrate a database with a 200 tables from Sybase SQL Anywhere to PostgreSQL,     but SQL Anywhere escapes special characters like a HEX values ( like \x0D \x2C . ).     PostgreSQL COPY FROM recognize only OCT values ( lie \001 ... ) 2. How-to it' easy :)))