Revision 12305
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 2657 | 2657 |
|
| 2658 | 2658 |
|
| 2659 | 2659 |
-- |
| 2660 |
-- Name: show_views_like(text, text); Type: FUNCTION; Schema: util; Owner: - |
|
| 2661 |
-- |
|
| 2662 |
|
|
| 2663 |
CREATE FUNCTION show_views_like(schema text, name_regexp text) RETURNS SETOF regclass |
|
| 2664 |
LANGUAGE sql STABLE |
|
| 2665 |
AS $_$ |
|
| 2666 |
SELECT oid FROM pg_class |
|
| 2667 |
WHERE relnamespace = util.schema_oid($1) AND relkind = 'v' AND relname ~ $2 |
|
| 2668 |
$_$; |
|
| 2669 |
|
|
| 2670 |
|
|
| 2671 |
-- |
|
| 2660 | 2672 |
-- Name: table2hstore(regclass); Type: FUNCTION; Schema: util; Owner: - |
| 2661 | 2673 |
-- |
| 2662 | 2674 |
|
Also available in: Unified diff
schemas/util.sql: added show_views_like()