I am inserting data into temp table and its working fine. below is the psedo sql code for the same
with cte as( ) select * into temp_table from cte
with this approach data is inserted very fast into temp table. As per my knowleged temp table is deleted once the session is closed. but my temp table is not deleted even if closed my pgadmin connection.
My question is does temp table in postgresql are deleted automatically or they remains on disk space until we delete them.