Re: [GENERAL] Means to emulate global temporary table

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: [GENERAL] Means to emulate global temporary table
Дата
Msg-id e2ee157a-6ead-0699-5d3c-5a73b01b6ec8@hogranch.com
обсуждение исходный текст
Ответ на [GENERAL] Means to emulate global temporary table  (Ian Lewis <ilewismsl@gmail.com>)
Список pgsql-general
On 1/11/2017 2:07 PM, Ian Lewis wrote:
> I am working on porting from an SQL Anywhere server that has support
> for general temporary tables. It appears that PostgreSQL does not have
> such support.

postgres temporary tables are either local to a transaction, or to a
connection/session, and are automatically deleted when the transaction
or session terminates.

how do these 'general temporary tables' differ from regular tables that
you create on demand, then delete when you're done with them?


--
john r pierce, recycling bits in santa cruz



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

Предыдущее
От: philolilou
Дата:
Сообщение: [GENERAL] Database of articles, LaTeX code and pictures
Следующее
От: John R Pierce
Дата:
Сообщение: Re: [GENERAL] Database of articles, LaTeX code and pictures