Skip to content

Instantly share code, notes, and snippets.

@geobabbler
Last active June 9, 2017 17:29
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save geobabbler/76eb5db4ec685833a61e69bd58a57522 to your computer and use it in GitHub Desktop.
-- 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