BEGIN;

--aquagis
 TRUNCATE aquagis.chambers,
  aquagis.chambers_sewers,
  aquagis.controls,
  aquagis.curves,
  aquagis.edge_data,
  aquagis.face  ,
  aquagis.fittings,
  aquagis.hydrants  ,
  aquagis.junctions,
  aquagis.junctions_sewers,
  aquagis.locks,
  aquagis.manholes,
  aquagis.manholes_sewers,
  aquagis.node  ,
  aquagis.objects_sewers,
  aquagis.options,
  aquagis.outlets_sewers,
  aquagis.partitions  ,
  aquagis.pipes  ,
  aquagis.pipes_sewers,
  aquagis.pumping_stations_sewers,
  aquagis.pumps,
  aquagis.relation,
  aquagis.reservoirs,
  aquagis.tanks,
  aquagis.terminals  ,
  aquagis.terminals_sewers,
  aquagis.valves,
  aquagis.water_analysis,
  aquagis.watermeters  ,
--basemaps
  basemaps.etykieta,
  basemaps.obiekt,
--layers
  layers.layers_index,
--public
  public.attachments  ,
  public.baselayers  ,
  public.comments  ,
  public.documentation  ,
  public.documentation_attachments  ,
  public.events  ,
  public.groups  ,
  public.history  ,
  public.history_index  ,
  public.moderations  ,
  public.notes  ,
--   dicts,
--   ref_dicts,
  public.spatial_ref_sys  ,
  public.tokens  ,
  public.users  ,
  public.versions  ,
--registry
  registry.attachments  ,
  registry.comments  ,
  registry.failures  ,
  registry.hydrant_inspection,
  registry.maintenance  ,
  registry.misc  ,
  registry.schedules  ,
  registry.table_objects  ,
  registry.tasks  ,
--sessions
--  chambers,
--  --chambers_sewers  ,
  sessions.controls  ,
  sessions.edge_data  ,
  sessions.face  ,
  sessions.fittings  ,
  sessions.hydrants,
  sessions.junctions  ,
  sessions.junctions_sewers  ,
  sessions.locks  ,
  sessions.manholes  ,
  sessions.manholes_sewers  ,
  sessions.node  ,
  sessions.objects_sewers  ,
  sessions.outlets_sewers  ,
  sessions.partitions  ,
  sessions.pipes  ,
  sessions.pipes_sewers  ,
  sessions.pumping_stations_sewers  ,
  sessions.pumps  ,
  sessions.relation  ,
  sessions.reservoirs  ,
  sessions.sessions_index  ,
  sessions.tanks  ,
  sessions.terminals  ,
  sessions.terminals_sewers  ,
  sessions.valves  ,
  sessions.watermeters RESTART IDENTITY CASCADE  ;
--topology zostaje

COMMIT;