Revision 8779
Added by Aaron Marcuse-Kubitza almost 12 years ago
vegbien.sql | ||
---|---|---|
3776 | 3776 |
|
3777 | 3777 |
|
3778 | 3778 |
-- |
3779 |
-- Name: range_modeling_input; Type: VIEW; Schema: public; Owner: - |
|
3780 |
-- |
|
3781 |
|
|
3782 |
CREATE VIEW range_modeling_input AS |
|
3783 |
SELECT analytical_stem_view.datasource AS source, analytical_stem_view."institutionCode" AS first_publisher, analytical_stem_view."decimalLatitude" AS latitude_deg, analytical_stem_view."decimalLongitude" AS longitude_deg, analytical_stem_view.geovalid_bien AS geovalid, analytical_stem_view."speciesBinomialWithMorphospecies" AS species_taxon_name FROM analytical_stem_view; |
|
3784 |
|
|
3785 |
|
|
3786 |
-- |
|
3779 | 3787 |
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: |
3780 | 3788 |
-- |
3781 | 3789 |
|
... | ... | |
8953 | 8961 |
|
8954 | 8962 |
|
8955 | 8963 |
-- |
8964 |
-- Name: range_modeling_input; Type: ACL; Schema: public; Owner: - |
|
8965 |
-- |
|
8966 |
|
|
8967 |
REVOKE ALL ON TABLE range_modeling_input FROM PUBLIC; |
|
8968 |
REVOKE ALL ON TABLE range_modeling_input FROM bien; |
|
8969 |
GRANT ALL ON TABLE range_modeling_input TO bien; |
|
8970 |
GRANT SELECT ON TABLE range_modeling_input TO bien_read; |
|
8971 |
|
|
8972 |
|
|
8973 |
-- |
|
8956 | 8974 |
-- Name: revision; Type: ACL; Schema: public; Owner: - |
8957 | 8975 |
-- |
8958 | 8976 |
|
Also available in: Unified diff
schemas/vegbien.sql: added range_modeling_input view