Matthias Apitz <guru@xxxxxxxxxxx> writes:
> I want to search in a VCHAR column for a string with two TAB at the end.
> I tried some things w/o any luck, like:
> select * from acq_vardata where name=concat('Test202112', 9, 9);
> select * from acq_vardata where name=concat('Test202112', '\t\t');
By default, backslash is not magic in SQL literals. The right way
to spell that is something like
select * from acq_vardata where name = E'Test202112\t\t';
See the discussion of "escape strings" in
https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS
regards, tom lane
