Revision 12234
Added by Aaron Marcuse-Kubitza almost 11 years ago
| util.sql | ||
|---|---|---|
| 1564 | 1564 |
|
| 1565 | 1565 |
|
| 1566 | 1566 |
-- |
| 1567 |
-- Name: materialize_view(text, regclass); Type: FUNCTION; Schema: util; Owner: - |
|
| 1568 |
-- |
|
| 1569 |
|
|
| 1570 |
CREATE FUNCTION materialize_view(table_ text, view_ regclass) RETURNS void |
|
| 1571 |
LANGUAGE sql |
|
| 1572 |
AS $_$ |
|
| 1573 |
SELECT util.materialize_query($1, $$SELECT * FROM $$||$2) |
|
| 1574 |
$_$; |
|
| 1575 |
|
|
| 1576 |
|
|
| 1577 |
-- |
|
| 1578 |
-- Name: FUNCTION materialize_view(table_ text, view_ regclass); Type: COMMENT; Schema: util; Owner: - |
|
| 1579 |
-- |
|
| 1580 |
|
|
| 1581 |
COMMENT ON FUNCTION materialize_view(table_ text, view_ regclass) IS 'idempotent'; |
|
| 1582 |
|
|
| 1583 |
|
|
| 1584 |
-- |
|
| 1567 | 1585 |
-- Name: mk_const_col(col_ref, anyelement); Type: FUNCTION; Schema: util; Owner: - |
| 1568 | 1586 |
-- |
| 1569 | 1587 |
|
Also available in: Unified diff
schemas/util.sql: added materialize_view()