import.sql

postgrest ➤ psql -d goodfilm < data.sql
SET
SET
SET
SET
SET
SET
SET
COPY 2
ERROR:  invalid input syntax for integer: "1 Golden Lion Venice Film Festival  2014-01-01"
CONTEXT:  COPY competition, line 1, column id: "1 Golden Lion Venice Film Festival  2014-01-01"
 setval
--------
      2
(1 row)

COPY 35
ERROR:  invalid input syntax for integer: "1 Chuang ru zhe 2014-01-01  Xiaoshuai Wang  6.19999981  english"
CONTEXT:  COPY film, line 1, column id: "1 Chuang ru zhe 2014-01-01  Xiaoshuai Wang  6.19999981  english"
 setval
--------
     35
(1 row)

ERROR:  invalid input syntax for integer: "1 1 1 f"
CONTEXT:  COPY nominations, line 1, column id: "1 1 1 f"
 setval
--------
     35
(1 row)

SET
ERROR:  missing data for column "uri"
CONTEXT:  COPY projects, line 1: "goodfilm  \N  2015-03-16 17:05:50.556662+00 Jonathan Harrington jonathan@jonharrington.org"
ERROR:  missing data for column "script_hash"
CONTEXT:  COPY changes, line 1: "755e3fec2f92428d30a093e1477dcd493090708d  238196dc16257dff36e562ebf51548b9e3e4e1e5  appschmea goodfi..."
COPY 0
ERROR:  missing data for column "change_id"
CONTEXT:  COPY events, line 1: "deploy  755e3fec2f92428d30a093e1477dcd493090708d  appschmea goodfilm  Add schema for goodfilm object..."
ERROR:  invalid input syntax for type real: "1 2015-03-16 17:05:50.550235+00 Jonathan Harrington jonathan@jonharrington.org"
CONTEXT:  COPY releases, line 1, column version: "1 2015-03-16 17:05:50.550235+00 Jonathan Harrington jonathan@jonharrington.org"
COPY 0