PostGIS
Name
Drop_Nation_Tables_Generate_Script — Generates a script that drops all
tables in the specified schema that start with county_all,
state_all or state code followed by county or state.
Description
Generates a script that drops all tables in the specified schema that
start with county_all, state_all or state code followed by
county or state. This is needed if you are upgrading from
tiger_2010 to tiger_2011 data.
Availability: 2.1.0
Examples
SELECT drop_nation_tables_generate_script();
DROP TABLE tiger_data.county_all;
DROP TABLE tiger_data.county_all_lookup;
DROP TABLE tiger_data.state_all;
DROP TABLE tiger_data.ma_county;
DROP TABLE tiger_data.ma_state;