How to treat ' in Vertica

[xlstime]

Hi Guys,

Please help me, how to treat ' in vertica in clause

in Mysql i use \ to manage or control ' please suggest

for example in mysql

SELECT 'xlstime\'s';

please suggest in Vertica

[JimKnicely]

Hi,

The easiest way to deal with an apostrophe "'" in text is to simply use double apostrophes "''".

Example:

Single apostrophe:

Code: Select all

dbadmin=> SELECT 'xlstime\'s';
dbadmin'>

Double apostrophes:

Code: Select all

dbadmin=> SELECT 'xlstime\''s';
  ?column?
------------
 xlstime\'s
(1 row)