Re: Means to emulate global temporary table

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Means to emulate global temporary table
Date: 2017-01-11 23:23:10
Message-ID: e2ee157a-6ead-0699-5d3c-5a73b01b6ec8@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2017-01-11 23:24:56 Re: Database of articles, LaTeX code and pictures
Previous Message philolilou 2017-01-11 22:47:16 Database of articles, LaTeX code and pictures