database design with temporary tables

Поиск
Список
Период
Сортировка
От ourdiaspora
Тема database design with temporary tables
Дата
Msg-id IRuoNkHXtafj7Vm_RhI-AB56qHPVRSDRD95NmX9lxlsQvmsK361slJ4ONjoP0GvX8tNsyXUD5KF1TW21uJyh15BDdrQCDHFDvPXa1Nu-eVE=@protonmail.com
обсуждение исходный текст
Ответы Re: database design with temporary tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can we get rid of repeated queries from pg_dump?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: database design with temporary tables