Reset Postgres Counter

gistfile1.sql

skatr_development=# \d spots
                                      Table "public.spots"
   Column    |            Type             |                     Modifiers                      
-------------+-----------------------------+----------------------------------------------------
 id          | integer                     | not null default nextval('spots_id_seq'::regclass)


ALTER SEQUENCE spots_id_seq RESTART WITH 1;