Revision 13916
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 2575 | 2575 |
CREATE FUNCTION materialize_view(table_esc text, view_ regclass) RETURNS void |
| 2576 | 2576 |
LANGUAGE sql |
| 2577 | 2577 |
AS $_$ |
| 2578 |
SELECT util.materialize_query($1, $$SELECT * FROM $$||$2) |
|
| 2578 |
SELECT util.create_if_not_exists($$ |
|
| 2579 |
SELECT util.copy($$||util.quote_typed($2)||$$, $$||util.quote_typed($1)||$$) |
|
| 2580 |
$$); |
|
| 2579 | 2581 |
$_$; |
| 2580 | 2582 |
|
| 2581 | 2583 |
|
Also available in: Unified diff
schemas/util.sql: materialize_view(): use util.copy() instead of util.materialize_query() so that all view metadata is transferred