Skip to content

Instantly share code, notes, and snippets.

@wboykinm

wboykinm/view.sql

Created September 27, 2013 18:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wboykinm/6732943 to your computer and use it in GitHub Desktop.
Save wboykinm/6732943 to your computer and use it in GitHub Desktop.
Download ZIP
A view with all of GAUL in it
Raw
view.sql
CREATE VIEW gaulall AS
SELECT name, code, polygon FROM gaul0
UNION ALL
SELECT name, code, polygon FROM gaul1
UNION ALL
SELECT name, code, polygon FROM gaul2
ORDER BY code ASC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment