Re: Escaping strings for inclusion into SQL queries

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: Escaping strings for inclusion into SQL queries
Дата
Msg-id tgsne9uks9.fsf@mercury.rus.uni-stuttgart.de
обсуждение исходный текст
Ответ на Re: Escaping strings for inclusion into SQL queries  ("Mitch Vincent" <mvincent@cablespeed.com>)
Список pgsql-hackers
"Mitch Vincent" <mvincent@cablespeed.com> writes:

> Perhaps I'm not thinking correctly but isn't it the job of the application
> that's using the libpq library to escape special characters?

Yes, it is.

> I guess I don't see a down side though, if it's implemented
> correctly to check and see if characters are already escaped before
> escaping them (else major breakage of existing application would
> occur)..

You can't do this automatically because the strings needing escaping
are not marked in any way at the moment.

-- 
Florian Weimer                       Florian.Weimer@RUS.Uni-Stuttgart.DE
University of Stuttgart           http://cert.uni-stuttgart.de/
RUS-CERT                          +49-711-685-5973/fax +49-711-685-5898


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alex Pilosov
Дата:
Сообщение: Re: Escaping strings for inclusion into SQL queries
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Full Text Indexing