Re: [GENERAL] Means to emulate global temporary table - Mailing list pgsql-general

From John R Pierce
Subject Re: [GENERAL] Means to emulate global temporary table
Date
Msg-id e2ee157a-6ead-0699-5d3c-5a73b01b6ec8@hogranch.com
Whole thread Raw
In response to [GENERAL] Means to emulate global temporary table  (Ian Lewis <ilewismsl@gmail.com>)
List 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 by date:

Previous
From: philolilou
Date:
Subject: [GENERAL] Database of articles, LaTeX code and pictures
Next
From: John R Pierce
Date:
Subject: Re: [GENERAL] Database of articles, LaTeX code and pictures