Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
-- Materialized View: public.mvw_cellular_test
CREATE MATERIALIZED VIEW public.mvw_cellular_test AS
SELECT cellular_test.id,
cellular_test.geom,
cellular_test.licensee,
cellular_test.loccity,
us_states_lookup.name AS state_name
FROM cellular_test
INNER JOIN us_states_lookup ON cellular_test.locstate::text = us_states_lookup.abbr::text
WITH DATA;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment