Tijo P Elias
Reputation: 1
Temp table in postgresql is getting dropped at the end of the session. How to solve it?
At the end of the current session the table is getting dropped, and all the values is lost. What can I do to solve this issue?
Upvotes: 0
Views: 1494
Answers (1)
Pavel Stehule
Reputation: 45930
Postgresql has not global temp tables. There is not any clean solution.
Upvotes: 1
Related Questions
- Make temp table permanent
- Can't find temporary table in pg_class
- Dropping of temp tables in PostgreSQL?
- How to avoid dropping static table when dropping temp table
- PostgreSQL TEMP table alternating between exist and not exist
- postgreSQL doesnt use temp_tablespace
- Temp Table creation is throwing error in same session even dropping and recreating also
- Can't drop temp table in Postgres function: "being used by active queries in this session"
- Postgres and temporary tables
- problem with TEMPORARY TABLE