On Tue, Apr 7, 2009 at 7:12 PM, Kenneth Tilton <kentilton@xxxxxxxxx> wrote: > > > Scott Marlowe wrote: >> >> You can use a different method if you need a table available to the >> same session. Create a schema based on the session id, and put your >> temp tables there, only don't call them temp tables. You'll either >> need to make sure you always clean up your temp schema your session >> created or come up with a daemon that comes along every hour or so and >> kills off old schemas that aren't in use anymore. > > I am LMAO because Lisp (my server-side lang) does this to noobs, too: three > (at least) ways to do everything. Well, if all things are equal dropping one > schema and not kludging up mangled table names has a lot of appeal. Thx. Schemas, search_path and views together can let you do some pretty cool things in terms of integrating external postgresql based apps with each other. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
