| From: | Hassan Schroeder <hassan(dot)schroeder(at)gmail(dot)com> |
|---|---|
| To: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
| Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: How to correctly include double quotes in an insert statement |
| Date: | 2019-03-28 15:53:24 |
| Message-ID: | CACmC4yBO0pcS0NHy-+HMKh0=QvQD-RkE5nv9F0Z6JyVgQA8YYw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Wed, Mar 27, 2019 at 9:14 AM JORGE MALDONADO <jorgemal1960(at)gmail(dot)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(dot)schroeder(at)gmail(dot)com
twitter: @hassan
Consulting Availability : Silicon Valley or remote
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Alberto Rodriguez Solana | 2019-03-28 16:47:25 | Re: ERROR on database index |
| Previous Message | JORGE MALDONADO | 2019-03-28 13:30:13 | Re: How to correctly include double quotes in an insert statement |