From 50c8f9bad5b787ecc891a51732322df4d60a948e Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Thu, 4 Jan 2018 16:35:31 +0000 Subject: [PATCH] share/sql/zipcode.sql --- share/sql/zipcode.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/share/sql/zipcode.sql b/share/sql/zipcode.sql index 36172f38..103a7cee 100644 --- a/share/sql/zipcode.sql +++ b/share/sql/zipcode.sql @@ -23,5 +23,5 @@ CREATE INDEX IF NOT EXISTS zipcode_name_namex ON zipcode (name); -- \copy zipcode from stdin with delimiter E'\t' null as ''; BEGIN TRANSACTION; DELETE FROM zipcode; -copy zipcode from stdin with (format 'text'); +COPY zipcode FROM stdin WITH (format 'text'); COMMIT; -- 2.47.3