hi all,
i am struggling with temp tables. i have a statement like CREATE TEMP
TABLE test (a BIGINT);
it executes successfully, hence i know that the table has been created.
but i cant see the table within the DB using PGADMIN. if i do SELECT *
FROM test; it returns 0 records, but it still tells me that the table
exists with no data inside it. if i do a DROP TABLE test; it deletes
the table too. so everything is pointing to the fact that the table is
created, contains no data, but i cant see it. there is only one schema
(public) too.
can somebody please help me out.
thanks.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
