Table "public.frontend_pct"
      Column       │          Type           │ Modifiers
───────────────────┼─────────────────────────┼───────────
 code              │ character varying(3)    │ not null
 name              │ character varying(200)  │
 boundary          │ geometry(Geometry,4326) │
 org_type          │ character varying(9)    │ not null
 managing_group_id │ character varying(3)    │
 address           │ character varying(400)  │
 close_date        │ date                    │
 open_date         │ date                    │
 postcode          │ character varying(10)   │

gr2ogr -update -nln frontend_pct -f PostgreSQL PG:"host=127.0.0.1 dbname='$DB_NAME' user='$DB_USER' password='$DB_NAME'" myfile.KML

FAILED: Layer frontend_pct already exists, and -append not specified.
        Consider using -append, or -overwrite.
ERROR 1: Terminating translation prematurely after failed
translation of layer Layer #0 (use -skipfailures to skip errors)