aports - main/postgresql18/pltcl_create

13 lines · 522 B

1	-- Create tables needed for PL/Tcl autoloading. This script should be run by
2	-- the database administrator only.
3	--
4	-- Statements in this script are extracted from pltcl_loadmod script.
5	--
6	-- Author: G.J.R. Timmer
7	-- Date: 2017-01-28
8
9	create table pltcl_modules (modname name, modseq int2, modsrc text);
10	create index pltcl_modules_i on pltcl_modules using btree (modname name_ops);
11
12	create table pltcl_modfuncs (funcname name, modname name);
13	create index pltcl_modfuncs_i on pltcl_modfuncs using hash (funcname name_ops);