Revision 11656
Added by Aaron Marcuse-Kubitza about 11 years ago
| schemas/util.sql | ||
|---|---|---|
| 1833 | 1833 |
CREATE FUNCTION show_create_view(view_ regclass) RETURNS text |
| 1834 | 1834 |
LANGUAGE sql STABLE |
| 1835 | 1835 |
AS $_$ |
| 1836 |
SELECT $$CREATE OR REPLACE VIEW $$||$1||$$ AS $$||pg_get_viewdef($1) |
|
| 1836 |
SELECT $$CREATE OR REPLACE VIEW $$||$1||$$ AS $$||pg_get_viewdef($1)||$$; |
|
| 1837 |
$$||util.show_grants_for($1) |
|
| 1837 | 1838 |
$_$; |
| 1838 | 1839 |
|
| 1839 | 1840 |
|
Also available in: Unified diff
schemas/util.sql: show_create_view(): also include GRANT statements, which are necessary to fully re-create the view