jwsacksteder(at)ramprecision(dot)com writes:
> 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.
Postgres 7.3, right?
That's a schema, not a table. The temporary table is in that schema.
You shouldn't need to do anything special, though. What are you
doing, exactly, and what error do you get?
-Doug