Project

General

Profile

« Previous | Next » 

Revision 12138

schemas/vegbien.sql: added rm(), which deletes this schema

View differences:

vegbien.sql
1313 1313

  
1314 1314

  
1315 1315
--
1316
-- Name: rm(anyelement); Type: FUNCTION; Schema: public; Owner: -
1317
--
1318

  
1319
CREATE FUNCTION rm(schema_null anyelement DEFAULT NULL::source) RETURNS void
1320
    LANGUAGE plpgsql
1321
    AS $$
1322
BEGIN
1323
	PERFORM set_config('search_path', util.schema_ident(schema_null), true);
1324
	PERFORM util.schema_bundle_rm(util.schema_ident(schema_null));
1325
END;
1326
$$;
1327

  
1328

  
1329
--
1330
-- Name: FUNCTION rm(schema_null anyelement); Type: COMMENT; Schema: public; Owner: -
1331
--
1332

  
1333
COMMENT ON FUNCTION rm(schema_null anyelement) IS 'deletes this schema.
1334

  
1335
usage: SELECT public_schema.rm()
1336

  
1337
secure against renamings of the public schema.
1338

  
1339
schema_null: identifies which schema to publish. the default value is usually fine.
1340
';
1341

  
1342

  
1343
--
1316 1344
-- Name: rm_version_suffix(text); Type: FUNCTION; Schema: public; Owner: -
1317 1345
--
1318 1346

  

Also available in: Unified diff