Revision 12670
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 3495 | 3495 |
-- Name: show_relations_like(text, text, character[]); Type: FUNCTION; Schema: util; Owner: - |
| 3496 | 3496 |
-- |
| 3497 | 3497 |
|
| 3498 |
CREATE FUNCTION show_relations_like(name_regexp text, schema_regexp text DEFAULT ''::text, types character[] DEFAULT ARRAY['r'::text, 'v'::text]) RETURNS SETOF regclass |
|
| 3498 |
CREATE FUNCTION show_relations_like(name_regexp text, schema_regexp text DEFAULT ''::text, types character[] DEFAULT ARRAY['c'::text, 'r'::text, 'v'::text]) RETURNS SETOF regclass
|
|
| 3499 | 3499 |
LANGUAGE sql STABLE |
| 3500 | 3500 |
AS $_$ |
| 3501 | 3501 |
SELECT oid FROM pg_class |
Also available in: Unified diff
bugfix: schemas/util.sql: show_relations_like(): also need to include composite types, as these are also relations (and are expected to be included by callers of show_relations_like())