Revision 12134
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1887 | 1887 |
|
| 1888 | 1888 |
|
| 1889 | 1889 |
-- |
| 1890 |
-- Name: schema_bundle_get_schemas(text); Type: FUNCTION; Schema: util; Owner: - |
|
| 1891 |
-- |
|
| 1892 |
|
|
| 1893 |
CREATE FUNCTION schema_bundle_get_schemas(schema_bundle text) RETURNS SETOF text |
|
| 1894 |
LANGUAGE sql STABLE |
|
| 1895 |
AS $_$ |
|
| 1896 |
SELECT nspname::text FROM pg_namespace WHERE nspname ~ ('^'||$1||'(?=\y|_)')
|
|
| 1897 |
$_$; |
|
| 1898 |
|
|
| 1899 |
|
|
| 1900 |
-- |
|
| 1890 | 1901 |
-- Name: schema_ident(anyelement); Type: FUNCTION; Schema: util; Owner: - |
| 1891 | 1902 |
-- |
| 1892 | 1903 |
|
Also available in: Unified diff
schemas/util.sql: added schema_bundle_get_schemas()