Revision 12240
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1735 | 1735 |
CREATE FUNCTION mk_source_col(table_ regclass) RETURNS void |
| 1736 | 1736 |
LANGUAGE sql STRICT |
| 1737 | 1737 |
AS $_$ |
| 1738 |
SELECT util.mk_const_col(($1, 'source'), util.table_schema($1))
|
|
| 1738 |
SELECT util.mk_const_col(($1, 'source'), util.schema($1)) |
|
| 1739 | 1739 |
$_$; |
| 1740 | 1740 |
|
| 1741 | 1741 |
|
| ... | ... | |
| 2457 | 2457 |
|
| 2458 | 2458 |
|
| 2459 | 2459 |
-- |
| 2460 |
-- Name: table_schema(regclass); Type: FUNCTION; Schema: util; Owner: -
|
|
| 2460 |
-- Name: schema(regclass); Type: FUNCTION; Schema: util; Owner: - |
|
| 2461 | 2461 |
-- |
| 2462 | 2462 |
|
| 2463 |
CREATE FUNCTION table_schema(table_ regclass) RETURNS text
|
|
| 2463 |
CREATE FUNCTION schema(table_ regclass) RETURNS text |
|
| 2464 | 2464 |
LANGUAGE sql STABLE |
| 2465 | 2465 |
AS $_$ |
| 2466 | 2466 |
SELECT nspname::text FROM pg_namespace WHERE oid = (SELECT relnamespace FROM pg_class WHERE oid = $1) |
Also available in: Unified diff
schemas/util.sql: table_schema(): renamed to schema(regclass) for consistency with other schema(...) functions