How to select a single quoted column using postgres

Question

Select COLUMN_name  
from TABLE_name 
where COLUMN NAME = 'something's'

While executing this query in PostgreSQL, it is showing an error as like below, syntax error at or near "S".

If you study this in your SQL editor, does anything pop-out at you? Even just studying this with your eyes, does the embedded **single quote** mean anything of importance? — Dave Alperovich, Nov 06 '13 at 08:02

score 2 · Answer 1 · edited May 23 '17 at 12:06

2

The apostrophe in KEPLER'S is terminating the string early. Escape it, and proofread next time.

Select CONCEPTNAME from KM_CONCEPT_MAST where CONCEPTNAME='KEPLER''S LAWS OF PLANETARY MOTION'

edited May 23 '17 at 12:06

Community

answered Nov 06 '13 at 06:01

Matt Ball

1 Answers1