Re: [SQL] Inserting a path into Database

2007-06-04 Thread Shoaib Mir
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 Ente

[SQL] Inserting a path into Database

2007-06-04 Thread Ranieri Mazili
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)-