| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | James Hartley <jjhartley(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: moving CSV data into table? |
| Date: | 2011-09-02 19:20:54 |
| Message-ID: | 4E612C96.1050302@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On 09/02/2011 12:07 PM, James Hartley wrote:
> On Fri, Sep 2, 2011 at 11:16 AM, Steve Crawford
> <scrawford(at)pinpointresearch(dot)com
> <mailto:scrawford(at)pinpointresearch(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | e-letter | 2011-09-05 08:04:47 | grant database access |
| Previous Message | James Hartley | 2011-09-02 19:07:59 | Re: moving CSV data into table? |