Skip to content

Instantly share code, notes, and snippets.

@rastermanden

rastermanden/stat2pg

Created April 16, 2015 11:16
Show Gist options
  • Save rastermanden/3d8d95eaa4f2001ee69f to your computer and use it in GitHub Desktop.
Save rastermanden/3d8d95eaa4f2001ee69f to your computer and use it in GitHub Desktop.
Download ZIP
statistikbanken til postgresql
Raw
stat2pg
DROP TABLE IF EXISTS stat.folketal;
CREATE TABLE stat.folketal
(
komkode character varying,
tid character varying,
antal integer
);
COPY stat.folketal
FROM PROGRAM
'curl "http://api.statbank.dk/v1/data/FOLK1/CSV?valuePresentation=Code&OMRÅDE=*&TID=2015K1"' CSV HEADER DELIMITER ';';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment