Revision 14339
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1645 | 1645 |
CREATE FUNCTION copy_data(from_ regclass, to_ regclass) RETURNS void |
| 1646 | 1646 |
LANGUAGE sql |
| 1647 | 1647 |
AS $_$ |
| 1648 |
SELECT util.eval($$INSERT INTO $$||$2||$$ SELECT * FROM $$||$1) |
|
| 1648 |
SELECT util.eval($$INSERT INTO $$||$2||$$ SELECT * FROM $$||$1); |
|
| 1649 |
SELECT util.analyze_(to_); |
|
| 1649 | 1650 |
$_$; |
| 1650 | 1651 |
|
| 1651 | 1652 |
|
Also available in: Unified diff
fix: schemas/util.sql: copy_data(): also need to ANALYZE table after loading data into it