storing windows path strings

[Scott Frankel <leknarf(at)pacbell(dot)net>]

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