Christopher Kings-Lynne wrote:
> >     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.

Got it.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [EMAIL PROTECTED]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to