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 Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Sean Chittenden <sean@chittenden.org>
Re: [GENERAL] Temporary tables and miscellaneous schemas Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Sean Chittenden <sean@chittenden.org>
Re: [GENERAL] Temporary tables and miscellaneous schemas Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: [GENERAL] Temporary tables and miscellaneous schemas Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: [GENERAL] Temporary tables and miscellaneous schemas Bruce Momjian <pgman@candle.pha.pa.us>
Re: [GENERAL] Temporary tables and miscellaneous schemas Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: [GENERAL] Temporary tables and miscellaneous schemas Sean Chittenden <sean@chittenden.org>
>   	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
FAQ