| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Kevin Kempter" <kevin(at)kevinkempterllc(dot)com> |
| Cc: | "pgsql-general General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: temp table question |
| Date: | 2008-02-02 04:32:36 |
| Message-ID: | dcc563d10802012032t3fa56011t1aef9e9b21dccd66@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Feb 1, 2008 9:06 PM, Kevin Kempter <kevin(at)kevinkempterllc(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ted Byers | 2008-02-02 05:47:45 | Re: arrays of floating point numbers / linear algebra operations into the DB |
| Previous Message | brian | 2008-02-02 04:26:20 | Re: temp table question |