> Is it possible to create a temporary table on the server, work with it
> a bit and then delete it?

Not directly. Temporary tables are not implemented.

Depending on your need, you could simulate the temporary table using a
real table and a context variable such as CURRENT_TRANSACTION or a
generator value. The main problems are that you need to perform the
cleanup yourself (ie, delete from the table) and it may be prone to
accumulating garbage.

Avoid creating and dropping real tables though, because some of the
internal numbers that get dished out are finite, large enough to not
be hit in normal use unless normal use means dropping and creating
tables many times on an average day.

Adam