Re: Quoting routines in libpq - Mailing list pgsql-general

From Denis Perchine
Subject Re: Quoting routines in libpq
Date
Msg-id 0007181213430M.06956@dyp
Whole thread Raw
In response to Re: Quoting routines in libpq  (Vince Vielhaber <vev@michvhf.com>)
List pgsql-general
> > > Just a small question: why there is not any quoting routine in libpq.
> >
> > Can you give an example of what it should do?
>
> Just as a guess, something that parses a string and escapes single quotes,
> backslashes and stuff like that.  I rolled my own for apps that I worked
> on that needed one, lately I've been using PHP which has such a function
> and a reversing function.

You are perfectly right!!! :-)))) Problem is that for each database you should escape
their own set of chars. And also there are lots of escaping types. Like some DBs
prefer to escape single quote as two single quotes, some as slash and single quote.

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

pgsql-general by date:

Previous
From: John McKown
Date:
Subject: Re: MOD
Next
From: Steve Heaven
Date:
Subject: Re: ordering of 'where' sub clauses