Temporary table and dump

From: Emmanuel Quevillon <tuco(at)pasteur(dot)fr>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Temporary table and dump
Date: 2015-07-17 08:32:50
Message-ID: 55A8BDB2.2080003@pasteur.fr
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all

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?

Thanks for any clue.

Emmanuel
--
-------------------------
Emmanuel Quevillon
CIB, Centre Informatique pour la Biologie
Institut Pasteur
+33 1 44 38 95 98
tuco at_ pasteur dot fr
-------------------------

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Albe Laurenz 2015-07-17 08:43:33 Re: Temporary table and dump
Previous Message Birchall, Austen 2015-07-16 09:59:20 Re: pg_restore hangs for en_US.utf8 in the UK