From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pdxpug(at)postgresql(dot)org |
Subject: | Re: Syntax Error? |
Date: | 2011-02-03 18:25:32 |
Message-ID: | alpine.LNX.2.00.1102031021340.25032@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
On Thu, 3 Feb 2011, Jeff Davis wrote:
> Is it possible that the values themselves have the quotation marks?
Jeff,
Yes, they do because they're strings:
\N \N 'GW-24' 1993-10-08 'Arsenic' 0.008 \N \N
> Maybe try:
> select * from monitor where location = '''GW-24''';
Yes, this works.
Shouldn't the strings be delimited by single quotes in the .csv file from
which the table is created?
There must be someting I've done incorrectly because all the char columns
have single quotes in the dumped file, but I cannot use single quotes to
select them. I should fix this while I have only 31K rows in the table!
Thanks,
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2011-02-03 18:27:56 | Re: Syntax Error? |
Previous Message | Ewan, Michael | 2011-02-03 18:20:44 | Re: Syntax Error? |