Open In App
Related Articles

PostgreSQL – Removing Temporary Table

Improve Article
Save Article
Like Article

In PostgreSQL, one can drop a temporary table by the use of the DROP TABLE statement.

Syntax: DROP TABLE temp_table_name;

Unlike the CREATE TABLE statement, the DROP TABLE statement does not have the TEMP or TEMPORARY keyword created specifically for temporary tables. To demonstrate the process of dropping a temporary table let’s first create one by following the below instructions.
First, we create a sample database(say, test) to add a temporary table using the below statement:


After creating the database we switch into it using the following command:

\c test;

Now we add a temporary table (say, mytemp) to the test database as below:


Verify if the table has been created using the below statement:

SELECT * FROM mytemp;

It should show you the below table:

Now that our temporary table is created we remove it in the below example.

We use the DROP TABLE statement inside the database test as follows to drop the temporary table:

DROP TABLE mytemp;

Now we verify if the table has been removed successfully using the below statement:

SELECT * FROM mytemp;


The above-shown error raised by PostgreSQL shows that the mytemp table doesn’t exist anymore.

Whether you're preparing for your first job interview or aiming to upskill in this ever-evolving tech landscape, GeeksforGeeks Courses are your key to success. We provide top-quality content at affordable prices, all geared towards accelerating your growth in a time-bound manner. Join the millions we've already empowered, and we're here to do the same for you. Don't miss out - check it out now!

Last Updated : 28 Aug, 2020
Like Article
Save Article
Similar Reads