storing windows path strings

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