2 -- Selected TOC Entries:
6 DROP INDEX "ind_index_author2";
7 DROP INDEX "ind_index_author";
8 DROP INDEX "ind_index_title2";
9 DROP INDEX "ind_index_title";
10 DROP TABLE "index_author";
11 DROP PROCEDURAL LANGUAGE 'plpgsql';
14 DROP FUNCTION "plpgsql_call_handler" ();
17 DROP TABLE "index_title";
19 -- TOC Entry ID 2 (OID 831643)
21 -- Name: index_title Type: TABLE Owner: dpavlin
24 CREATE TABLE "index_title" (
25 "title" character varying(255)
31 -- TOC Entry ID 8 (OID 834826)
33 -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
36 CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
39 -- TOC Entry ID 9 (OID 834827)
41 -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
44 CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
49 -- TOC Entry ID 3 (OID 834828)
51 -- Name: index_author Type: TABLE Owner: dpavlin
54 CREATE TABLE "index_author" (
55 "author" character varying(255)
59 -- TOC Entry ID 4 (OID 831645)
61 -- Name: "ind_index_title" Type: INDEX Owner: dpavlin
64 CREATE INDEX ind_index_title ON index_title USING btree (title);
67 -- TOC Entry ID 5 (OID 831646)
69 -- Name: "ind_index_title2" Type: INDEX Owner: dpavlin
72 CREATE INDEX ind_index_title2 ON index_title USING btree (upper(title));
75 -- TOC Entry ID 6 (OID 834830)
77 -- Name: "ind_index_author" Type: INDEX Owner: dpavlin
80 CREATE UNIQUE INDEX ind_index_author ON index_author USING btree (author);
83 -- TOC Entry ID 7 (OID 834831)
85 -- Name: "ind_index_author2" Type: INDEX Owner: dpavlin
88 CREATE UNIQUE INDEX ind_index_author2 ON index_author USING btree (upper(author));