in reply to Keeping Perl DBI Quiet

If you are using Postgres you can create temporary tables with CREATE TEMP TABLE table_name .... These tables will only last until the end of the users session and then be deleted automatically. If you keep the connection to the database open for the whole lifetime of your app this may be useful.

--tidiness is the memory loss of environmental mnemonics

Replies are listed 'Best First'.
Re^2: Keeping Perl DBI Quiet
by Coruscate (Sexton) on Nov 26, 2003 at 09:25 UTC

    And if you just happen to be using mysql instead of Postgres, you're in luck. Slightly different syntax, but it's available (darn the cross-compatability, why can't they all be the same? :)). 

    # for mysql temporary table (exists until end of session)
CREATE TEMPORARY TABLE table_name(
  ...
);

    [download]

[reply]
[d/l]
      Actually I was being lazy, the form you gave is good for Postgres too.

      --tidiness is the memory loss of environmental mnemonics

[reply]
[d/l]

In Section Seekers of Perl Wisdom