Revision 5852
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 444 | 444 |
CREATE FUNCTION make_analytical_db() RETURNS void |
| 445 | 445 |
LANGUAGE sql |
| 446 | 446 |
AS $$ |
| 447 |
INSERT INTO analytical_db SELECT * FROM analytical_db_view |
|
| 447 |
INSERT INTO analytical_db SELECT * FROM analytical_db_view; |
|
| 448 |
INSERT INTO aggregated_analytical_db SELECT * FROM aggregated_analytical_db_view; |
|
| 448 | 449 |
$$; |
| 449 | 450 |
|
| 450 | 451 |
|
Also available in: Unified diff
schemas/vegbien.sql: make_analytical_db(): Also make new aggregated_analytical_db