Revision 11651
Added by Aaron Marcuse-Kubitza about 11 years ago
| util.sql | ||
|---|---|---|
| 1795 | 1795 |
|
| 1796 | 1796 |
|
| 1797 | 1797 |
-- |
| 1798 |
-- Name: show_create_view(regclass); Type: FUNCTION; Schema: util; Owner: - |
|
| 1799 |
-- |
|
| 1800 |
|
|
| 1801 |
CREATE FUNCTION show_create_view(view_ regclass) RETURNS text |
|
| 1802 |
LANGUAGE sql STABLE |
|
| 1803 |
AS $_$ |
|
| 1804 |
SELECT $$CREATE OR REPLACE VIEW $$||$1||$$ AS $$||pg_get_viewdef($1) |
|
| 1805 |
$_$; |
|
| 1806 |
|
|
| 1807 |
|
|
| 1808 |
-- |
|
| 1798 | 1809 |
-- Name: table2hstore(regclass); Type: FUNCTION; Schema: util; Owner: - |
| 1799 | 1810 |
-- |
| 1800 | 1811 |
|
Also available in: Unified diff
schemas/util.sql: added show_create_view()