CREATE EXTENSION postgis;
CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION postgis_tiger_geocoder;

GRANT USAGE ON SCHEMA tiger TO PUBLIC;
GRANT USAGE ON SCHEMA tiger_data TO PUBLIC;
GRANT SELECT, REFERENCES, TRIGGER
ON ALL TABLES IN SCHEMA tiger TO PUBLIC;
GRANT SELECT, REFERENCES, TRIGGER
ON ALL TABLES IN SCHEMA tiger_data TO PUBLIC;
GRANT EXECUTE
ON ALL FUNCTIONS IN SCHEMA tiger TO PUBLIC;
ALTER DEFAULT PRIVILEGES IN SCHEMA tiger_data
GRANT SELECT,  REFERENCES
ON TABLES TO PUBLIC;

SELECT declare_sect FROM tiger.loader_platform WHERE os='windows';
                  declare_sect
------------------------------------------------
 set TMPDIR=${staging_fold}temp
 set UNZIPTOOL="C:Program Files7-Zip7z.exe"
 set WGETTOOL="C:wget-1.11.4wget.exe"
 set PGBIN=C:Program FilesPostgreSQL9.5bin
 set PGPORT=5432
 set PGHOST=localhost
 set PGUSER=postgres
 set PGPASSWORD=pass
 set PGDATABASE=tiger
 set PSQL="%PGBIN%psql"
 set SHP2PGSQL="%PGBIN%shp2pgsql"
 cd ${staging_fold}

t
a
o /gisdata/nationscript.bat
SELECT loader_generate_nation_script('windows');
o