Re: display temp table structure?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: display temp table structure?
Дата
Msg-id 20068.984503527@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: display temp table structure?  (Limin Liu <limin@pumpkinnet.com>)
Список pgsql-general
Limin Liu <limin@pumpkinnet.com> writes:
> If backend does not keep temp_table_name, this looks like somthing
> impossible to do (to me).  (I hope my question makes sense.)

The backend does keep a temp table name mapping, but it's hidden in an
internal data structure that there's no way to read out.

Rather than invent some way to make that mapping visible, I have been
thinking that it might be possible to dispense with the special mapping
altogether once we have schemas (which hopefully will happen for 7.2).
I am imagining that temp tables might become ordinary tables that live
in a per-backend schema.  I haven't tried to work out the details yet,
though.

            regards, tom lane

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

Предыдущее
От: Limin Liu
Дата:
Сообщение: Re: display temp table structure?
Следующее
От: "David Wall"
Дата:
Сообщение: Re: Data type for storing images?