Re: How to correctly include double quotes in an insert statement - Mailing list pgsql-novice

From Hassan Schroeder
Subject Re: How to correctly include double quotes in an insert statement
Date
Msg-id CACmC4yBO0pcS0NHy-+HMKh0=QvQD-RkE5nv9F0Z6JyVgQA8YYw@mail.gmail.com
Whole thread Raw
In response to How to correctly include double quotes in an insert statement  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List 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 by date:

Previous
From: JORGE MALDONADO
Date:
Subject: Re: How to correctly include double quotes in an insert statement
Next
From: Frank Alberto Rodriguez Solana
Date:
Subject: Re: ERROR on database index