If I try to make a temporary table like this-
create temporary table current_inventory AS
select * from inventory where qty > 0
- I get a table called 'pg_temp_4473_0' instead of my specified name.
What gives? Why did this stop working for me?
(Please respond directly to me. I'm not currently subscribed)