retrieving metadata with restrictions

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 16
Joined: Mon 27 Jun 2005 21:12

retrieving metadata with restrictions

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 "\" ?

Posts: 140
Joined: Mon 08 Nov 2004 12:07

retrieving metadata with restrictions

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.

Post Reply