-- Name: 2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" AS

 SELECT "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".datasource,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".country,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".locality,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".latitude,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".longitude,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".coord_uncertainty_m,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".georef_sources,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".georef_protocol,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".is_geovalid,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".is_new_world,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".is_location_cultivated,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".custodial_institution_codes,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".collection_code,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".catalog_number,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".recorded_by,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".date_collected,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".verbatim_family,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".verbatim_scientific_name,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".identified_by,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".date_identified,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".identification_remarks,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".family_matched,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".name_matched,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".name_matched_author,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".taxonomic_status,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_family,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_genus,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_specific_epithet,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_species_binomial,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_taxon_name_no_author,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_author,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_taxon_name_with_author,

    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".is_cultivated

   FROM "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private"

  WHERE ("2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".datasource = ANY (public_datasources()));

--

-- Name: 2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" FROM PUBLIC;

REVOKE ALL ON TABLE "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" FROM bien;

GRANT ALL ON TABLE "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" TO bien;

GRANT SELECT ON TABLE "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" TO bien_read;

--