Re: storing windows path strings

From: Scott Frankel <leknarf(at)pacbell(dot)net>
To: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: storing windows path strings
Date: 2010-01-30 00:23:56
Message-ID: 09F2B617-D557-4D41-853D-F39CCBDCDED1@pacbell.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Excellent! Mild testing so far, but it seems to work. Thanks!
Scott

On Jan 29, 2010, at 3:00 PM, Cédric Villemain wrote:

> 2010/1/29 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
>
> explicetely set ON the standard_conforming_string in the
> postgresql.conf
> *but* take care it don't break your application.
> INSERT INTO foo (name, dirpath) VALUES ('bar', 'c:\windows\path\to
> \bar');
>
>>
>>
>>
>>
>
>
>
> --
> Cédric Villemain

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Kramer 2010-01-30 01:21:33 Re: How to generate unique hash-type id?
Previous Message Devrim GÜNDÜZ 2010-01-29 23:58:17 Re: [GENERAL] Versions RSS page is missing version(s)