On Feb 1, 2008 9:06 PM, Kevin Kempter <kevin@xxxxxxxxxxxxxxxxxxx> wrote: > Hi list; > > If I create a temp table (i.e. create temp table xyz as select from ...) is > the scope of this table limited to a session. Meaning, can several sessions > all run the above create temp table statement all referencing the same temp > table name at the same time? Temp tables are only visible to the session that created them. See http://www.postgresql.org/docs/8.2/interactive/sql-createtable.html ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
