| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "'tuco(at)pasteur(dot)fr'" <tuco(at)pasteur(dot)fr>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Temporary table and dump |
| Date: | 2015-07-17 08:43:33 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B50F7346F@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Emmanuel Quevillon wrote:
> I've read from the doc that a temporary table is destroyed when a
> session ends.
>
> My question is then, is a temporary table saved into a dump if pg_dump
> is launched while the session that created the temporary table is not ended?
>
> Thus, during the pg_restore, the temporary table is re-created or not?
A temporary table will never be in a database dump.
The temporary table is only visible in the session that created it, and pg_dump
does not create temporary tables.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2015-07-17 13:43:10 | Re: Replication DB scenario |
| Previous Message | Emmanuel Quevillon | 2015-07-17 08:32:50 | Temporary table and dump |