Re: [GENERAL] Temporary tables and miscellaneous schemas

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: [GENERAL] Temporary tables and miscellaneous schemas
Дата
Msg-id 3FE8639E.8020908@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: [GENERAL] Temporary tables and miscellaneous schemas  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [GENERAL] Temporary tables and miscellaneous schemas
Список pgsql-patches
>       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

В списке pgsql-patches по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Quoting of psql \d output
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Quoting of psql \d output