i execute this query on SQL editor of pgAdmin III
CREATE TABLE cadastre.searchtable
(
searchstring text, --the search string (all lower case), e.g. "zürichstrasse 46, 8610 uster"
displaytext text NOT NULL, --the display text for the search combobox, e.g. "Zürichstrasse 46, 8610 Uster (address)"
search_category text, --should have a leading two digit number:, e.g.
--"03_parcels", where 03 is the order of the search categories, the number
--should be unique across all search tables
the_geom geometry, --the actual geometry
geometry_type text, --the geometry type as returned by ST_GeometryType(the_geom)
searchstring_tsvector tsvector, -- be sure to fill this with to_tsvector()
CONSTRAINT searchtable_pkey PRIMARY KEY (displaytext)
)
WITH (
OIDS=FALSE
);
GRANT SELECT ON TABLE cadastre.searchtable TO alle;
-- Index: cadastre.in_cadastre_searchstring_tsvector_gin
CREATE INDEX in_cadastre_searchstring_tsvector_gin
ON cadastre.searchtable
USING gin
(searchstring_tsvector);
but i can't execute query
ERROR: schema "cadastre" does not exist
********** Error **********
ERROR: schema "cadastre" does not exist
SQL state: 3F000
how to create cadastre schema?