initPQExpBuffer(&buf);
        printfPQExpBuffer(&buf,
!               "SELECT n.nspname AS \"%s\",\n"
!               "       u.usename AS \"%s\"\n"
                "FROM pg_catalog.pg_namespace n LEFT JOIN pg_catalog.pg_user u\n"
!               "       ON n.nspowner=u.usesysid\n"
!               "WHERE     n.nspname NOT LIKE 'pg_temp_%%' OR\n"
!               "          n.nspname = (current_schemas(true))[1]\n", /* temp schema 
is first */
                                          _("Name"),
                                          _("Owner"));
!       processNamePattern(&buf, pattern, true, false,
                                           NULL, "n.nspname", NULL,
                                           NULL);


Not that this is incorrect. You need to go:


LIKE 'pg\\\\_temp\\\\_%' probably.

Chris

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to