[GENERAL] storing windows path strings

[Scott Frankel]

Hi all,
What's the proper way to store directory path strings in a table,  
especially ones with backslashes like windows?

I'm currently using a prepared statement with bind value.  Do I need  
to pre-parse all user entries to identify any backslash characters  
before passing the string to my insert statement?

Searches through the documentation turned up references to  
escape_string_warning (boolean) and standard_conforming_strings  
(boolean).  I'm not sure I'll have access to server side config.

Thanks in advance!
Scott


eg:

CREATE TABLE foo (
        foo_id                          SERIAL          PRIMARY KEY,
        name                            VARCHAR(32)     UNIQUE NOT NULL,
        dirpath                         text            DEFAULT NULL);


INSERT INTO foo (name, dirpath) VALUES ('bar', 'c:\windows\path\to 
\bar');
--> WARNING:  nonstandard use of \\ in a string literal