Re: Problem with character ' (single quote) in text fields

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Jordi <jordil2(at)hotmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem with character ' (single quote) in text fields
Date: 2002-01-21 18:22:55
Message-ID: 20020121101903.L95108-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mon, 21 Jan 2002, Jordi wrote:

> The best solution for me should be if I could change the "start/end of a
> Postgresql string" from the single quote to the double quote (") or a
> similar character because now I have to do my own version of PQescapeString
> for every text field assuming the ' character could be there. Anyone knows
> if is possible to change it without modifying the Postgresql source code?

Double quotes (") already have a meaning for doing stuff with mixed case
attribute and table names, so I don't think that there's going to be a way
to change the quote character without modification.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Cao 2002-01-21 18:44:42 Foreign Key?
Previous Message Andrew Gould 2002-01-21 18:20:29 Re: frustration with database size <long>