Thanks a million to you all. Finally, as someone in the list suggested, i'm
using the double backslash (\\) and it seems it works ok.
The only problem i have is when i want to escape a single quote (') or the
backslash (\).
For example: i have one row with the value 'ONE\SECOND'
I try to recover it doing (from psql frontend):
select field1 from table1 where field1 ~* 'ONE\\\' ;
But it doesn't work, and the parser seems to be confused (it asks me to
close again the quote ' ).
The problem is the same with the single quote '. I've tried this:
select field1 from table1 where field1 ~* 'D\\'ALEMA' ;
But it doesn't work neither.
Thanks for your help.
Gabi :-)
