Re: How to correctly include double quotes in an insert statement

Поиск
Список
Период
Сортировка
От Hassan Schroeder
Тема Re: How to correctly include double quotes in an insert statement
Дата
Msg-id CACmC4yBO0pcS0NHy-+HMKh0=QvQD-RkE5nv9F0Z6JyVgQA8YYw@mail.gmail.com
обсуждение исходный текст
Ответ на How to correctly include double quotes in an insert statement  (JORGE MALDONADO <jorgemal1960@gmail.com>)
Список pgsql-novice
On Wed, Mar 27, 2019 at 9:14 AM JORGE MALDONADO <jorgemal1960@gmail.com> wrote:

> I have a tab-delimited text file from which I have to populate a table.
> After reviewing the data in such a text file I noticed that there are fields containing double quotes.

> However, I can see that using double quotes still causes some issues later when running our system.

There's no reason a text field shouldn't contain double-quote characters.

Maybe you should be more specific about the "issues" you're seeing;
"later" and "running our system" are both pretty vague.

-- 
Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
twitter: @hassan
Consulting Availability : Silicon Valley or remote



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

Предыдущее
От: JORGE MALDONADO
Дата:
Сообщение: Re: How to correctly include double quotes in an insert statement
Следующее
От: Frank Alberto Rodriguez Solana
Дата:
Сообщение: Re: ERROR on database index