Skip site navigation (1) Skip section navigation (2)

Re: moving CSV data into table?

From: James Hartley <jjhartley(at)gmail(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: moving CSV data into table?
Date: 2011-09-02 19:07:59
Message-ID: CAKeNXXs+xDz_han5vWHeeXzXCfhHSSBVevchF4rk5KGeFms9SA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Fri, Sep 2, 2011 at 11:16 AM, Steve Crawford <
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?

In response to

Responses

pgsql-novice by date

Next:From: Steve CrawfordDate: 2011-09-02 19:20:54
Subject: Re: moving CSV data into table?
Previous:From: Steve CrawfordDate: 2011-09-02 18:16:15
Subject: Re: moving CSV data into table?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group