Re: Temporary schemas
| От | Thom Brown |
|---|---|
| Тема | Re: Temporary schemas |
| Дата | |
| Msg-id | AANLkTimgiDKAFat-gLVwJMejzwEuOiekT0UzL1dKUPAL@mail.gmail.com обсуждение исходный текст |
| Ответ на | Temporary schemas (Thomas Kellerer <spam_eater@gmx.net>) |
| Ответы |
Re: Temporary schemas
Re: Temporary schemas |
| Список | pgsql-general |
On 1 November 2010 10:46, Thomas Kellerer <spam_eater@gmx.net> wrote:
Hello,
I have created a temporary table using
create temporary table foo
(
id integer
);
and noticed this was created in a schema called "pg_temp_2"
My question is:
is this always "pg_temp_2"?
Or will the name of the "temp schema" change?
If it isn't always the same, is there a way I can retrieve the schema name for temporary tables?
Regards
Thomas
You can use:
SELECT nspname
FROM pg_namespace
WHERE oid = pg_my_temp_schema();
to get the name of the current temporary schema for your session.
And it's always pg_temp_[nnn] as far as I'm aware, with a corresponding pg_toast_temp_[nnn] schema.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
В списке pgsql-general по дате отправления: