On 09/02/2011 12:07 PM, James Hartley wrote:
On Fri, Sep 2, 2011 at 11:16 AM, Steve Crawford
<scrawford@pinpointresearch.com> wrote:
Temporary tables are "unlogged", visible only to the current connection and deleted when the connection closes.
Thank you for these gems!
One question. Assuming I run psql on the same machine as the server itself, temporary tables will be deleted when psql exits?
That is correct - temporary tables disappear as soon as the connection closes. This is true whether the connection is local or remote and regardless of the client be it psql, Perl, Python, PHP, Prolog or even clients that don't start with "p".
Cheers,
Steve