Hello, we have user specific views with names that follow this pattern:
_table_username Strangely the following select: SELECT table_name FROM information_schema.views WHERE table_schema = current_schema() AND table_name LIKE '\_%\_username'; does also match views with names like table_username. This syntax does match as expected though: SELECT table_name FROM information_schema.views WHERE table_schema = current_schema() AND table_name LIKE E'\\_%\\_username'; Is this behaviour to be expected? Thank you very much, Peter -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin