Sanitize schema name

Поиск
Список
Период
Сортировка
От Ludovic Gasc
Тема Sanitize schema name
Дата
Msg-id CAON-fpF0Axc5XS7VPhzQNgsVsmTbkSuCxs5HT8+Ug9g8xCUsAw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Sanitize schema name  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список psycopg
Hi,

I want to sanitize the name of the schema in a SQL query, because the schema name depends on the client.

The issue is that I can't sanitize the name via the standard way of psycopg2, because it adds quotes around schema name.

I imagine it's the same issue with a table name. Do you have a suggestion to bypass that ?

For now, the most secure way I've found is to test the presence of the schema before launch each query, but not really efficient.

Regards.
--
Ludovic Gasc (GMLudo)

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Possible reasons for copy_from to never terminate?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Sanitize schema name