Re: [ADMIN] reg:FilePath error

2006-03-18 Thread Kevin Grittner
If you can't easily use the PostgreSQL extension to SQL, but need to have string literal behavior conform to the ANSI and ISO standards, I have submitted a patch for the 8.2 TODO item to support this. Since we needed it in production mode now, the patch I submitted was relative to the 8.1 stable b

Re: [ADMIN] reg:FilePath error

2006-03-15 Thread Thusitha Kodikara
Hi Sandhya, Try using two "\" characters if you want to insert on "\". For example use "C:\\ProgramFiles\\SampleFiles\\General\\back.doc" \b, \r, \t ... have special meanings. Please refer http://www.postgresql.org/docs/8.1/static/functions-matching.html Regards, -Thusitha --- sandhya <[EMAIL P

[ADMIN] reg:FilePath error

2006-03-15 Thread sandhya
Hi   When i am trying to insert a string data into my table which has few escape sequence characters...The entire string is not getting inserted. Like Ex: If my String data is   C:\ProgramFiles\SampleFiles\General\back.doc   C:\ProgramFiles\SampleFiles\General\rback.gif   C:\Program