In Sql Server, we can create temp table in sql editor like :

select * into #temp_sales_data from sales_data; -- this will create a temp table and insert data.

Please let us know what is the equivalent option in Postgres.

CodePudding user response：

You just create one using create temp table

create temp table temp_sales_data
as
select *
from sales_data;