Revision 5851
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 574 | 574 |
CREATE FUNCTION sync_analytical_db_to_view() RETURNS void |
| 575 | 575 |
LANGUAGE sql |
| 576 | 576 |
AS $$ |
| 577 |
DROP TABLE analytical_db; |
|
| 577 |
DROP TABLE IF EXISTS analytical_db;
|
|
| 578 | 578 |
CREATE TABLE analytical_db AS SELECT * FROM analytical_db_view; |
| 579 | 579 |
$$; |
| 580 | 580 |
|
Also available in: Unified diff
schemas/vegbien.sql: sync_analytical_db_to_view(): DROP TABLE: Use IF EXISTS in case analytical_db table has already been deleted, or not yet created