If you are on 8.1 you can use double qoutes ( 'C:\\Program Files\\My program' ) on in 8.2 you can use the new "backslash_quote (string)" setting.
You can find help on "backslash_quote (string)" at --> http://www.postgresql.org/docs/current/static/runtime-config-compatible.html -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 6/4/07, Ranieri Mazili <[EMAIL PROTECTED]> wrote:
Hello, I need to insert a path into a table, but because "\" I have a error by postgres, so how can I insert a path like bellow into a table: insert into production values ('C:\Program Files\My program'); I appreciate any help Thanks ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster