Re: temporary tables ?

On Jul 22, 2005, at 1:55 PM, Zlatko Matic wrote:

> Hello.
> I have some tables that are updated by several users in the same time
> and are used in queries for reports. Those tables have rows that are
> actualy copied from original tables that are not to be altered. There
> is a procedure that inserts rows for every user when connects, along
> with his username, so different users can't interfere with each other
> because every user has his own copy of rows that he can update, and
> records are filtered by current_user.
> Well, it's my heritage from MS Access, before I moved to Postgres,
> because there is no such thing as temporary table in Access...
> Now, I'm wondering is there any true advantage to implement temporary
> tables for each user, insted of one table with inserted rows with
> username for every user ?

Temporary tables are not per-user, but per-connection. A user can be
connected twice, but a temporary table created on one connection is not
visible from the other connection. Also, temporary tables are
temporary--they disappear after the connection is closed.