Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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?

share|improve this question

closed as off topic by underdark Sep 2 '12 at 18:09

Questions on Geographic Information Systems Stack Exchange are expected to relate to geographic information systems within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

Browse other questions tagged or ask your own question.