database design with temporary tables - Mailing list pgsql-general

From ourdiaspora
Subject database design with temporary tables
Date
Msg-id IRuoNkHXtafj7Vm_RhI-AB56qHPVRSDRD95NmX9lxlsQvmsK361slJ4ONjoP0GvX8tNsyXUD5KF1TW21uJyh15BDdrQCDHFDvPXa1Nu-eVE=@protonmail.com
Whole thread Raw
Responses Re: database design with temporary tables
List pgsql-general
Readers,

Some advice would be appreciated about appropriate tables to store temporary data.

Scenario:
User copies csv file of user data, presumably into some temporary table(s);
User selects data (read-only) from extant tables;
Web server combines user data with read-only data to produce content visible to user as html and/or pdf document;
User does not need to sign in to use web page, only the user e-mail address;
User data deleted (including e-mail address) after time (e.g. 24 hours) and/or user selects to receive combined data
viae-mail (after which all user data is automatically deleted). 

What part of the documention would be most relevant to read firstly, please?




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can we get rid of repeated queries from pg_dump?
Next
From: Adrian Klaver
Date:
Subject: Re: database design with temporary tables