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

Hassan Schroeder <[email protected]> Thu, 28 Mar 2019 08:53:24 -0700
Newsgroups gmane.comp.db.postgresql.novice
Message-ID <CACmC4yBO0pcS0NHy-+HMKh0=QvQD-RkE5nv9F0Z6JyVgQA8YYw@mail.gmail.com>
On Wed, Mar 27, 2019 at 9:14 AM JORGE MALDONADO <[email protected]> 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 ------------------------ [email protected]
twitter: @hassan
Consulting Availability : Silicon Valley or remote