title: shp2pgsql creates a table but psql reports "relation...does not exist"
body: <p>Using shp2pgsql to import a shapefile into a PostGIS database, all works fine:</p>
  
  <pre><code>Connection: host=localhost port=5432 user=aperrin dbname=tweets password='******' 
  Destination: public.County_2010Census_DP1
  Source File: /home/aperrin/Downloads/County_2010Census_DP1/County_2010Census_DP1
  Shapefile type: Polygon
  Postgis type: MULTIPOLYGON[2]
  Importing shapefile (3221 records)...
  Creating spatial index...
  
  Shapefile import completed.
  </code></pre>
  
  <p>In psql, \d shows:</p>
  
  <pre><code>                          List of relations
   Schema |                  Name                   |   Type   |  Owner   
  --------+-----------------------------------------+----------+----------
   public | County_2010Census_DP1                   | table    | aperrin
   public | County_2010Census_DP1_gid_seq           | sequence | aperrin
  </code></pre>
  
  <p>However:</p>
  
  <pre><code>tweets=&gt; \d County_2010Census_DP1
  Did not find any relation named "County_2010Census_DP1".
  tweets=&gt; select * from County_2010Census_DP1;
  ERROR:  relation "county_2010census_dp1" does not exist
  LINE 1: select * from County_2010Census_DP1;
  </code></pre>