Help Center> Data Warehouse Service> FAQs> Database Usage> What Are the Schemas Starting with pg_toast_temp* or pg_temp*?
What Are the Schemas Starting with pg_toast_temp* or pg_temp*?
When you query the schema list, the query result may contain schemas starting with pg_temp* or pg_toast_temp*, as shown in the following figure.
1 | SELECT * FROM pg_namespace; |
These schemas are created when temporary tables are created. Each session has an independent schema starting with pg_temp to ensure that the temporary tables are visible only to the current session. Therefore, you are not advised to manually delete schemas starting with pg_temp or pg_toast_temp during routine operations.
Temporary tables are visible only in the current session and are automatically deleted after the session ends. The corresponding schemas are also deleted.
Parent topic: Database Usage
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.