Revision 12327
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 2712 | 2712 |
CREATE FUNCTION show_views_like(name_regexp text, schema text) RETURNS SETOF regclass |
| 2713 | 2713 |
LANGUAGE sql STABLE |
| 2714 | 2714 |
AS $_$ |
| 2715 |
SELECT oid FROM pg_class |
|
| 2716 |
WHERE relnamespace = util.schema_oid($2) AND relkind = 'v' AND relname ~ $1 |
|
| 2717 |
ORDER BY relname |
|
| 2715 |
SELECT * FROM util.show_relations_like($1, $2, ARRAY['v']) |
|
| 2718 | 2716 |
$_$; |
| 2719 | 2717 |
|
| 2720 | 2718 |
|
Also available in: Unified diff
schemas/util.sql: show_views_like(): use util.show_relations_like()