retrieving metadata with restrictions

szinkopa · Post by **szinkopa** » Sat 02 Jul 2005 08:36

When retrieving metadata with GetSchame(), I may specify restrictions, which can contain % or _ characters as mask. What happens if the name contain one of this? Are the restrictions _always_ used in a LIKE statement, so then I should escape the mask characters that are part of the name. Is the escape character the "\" ?

Yuri · Post by **Yuri** » Mon 04 Jul 2005 11:50

We do not parse restrictions you specified. All restrictions are inserted directly into a LIKE expression.
For more information about using LIKE statement see PostgreSQL documentation.