Thread: SQL dump
05-02-12, 16:41 #1Registered User
- Join Date
- Apr 2012
Unanswered: SQL dump
Hey... Now that my PostgreSQL is finally working (the majority of it), I want to fill the database with existing data.
Therefor I got a dump.sql file which should create the tables, etc and fill them with data.
The dump fails when inserting data in this line:
COPY _user (id, firstname, lastname, type, activated, activationdate, birthday, city, comment, country, creationdate, emailaddress, horific, housenumber, password, passwordhash, postcode, salutation, street, username) FROM stdin; 1 Firstname Lastname USER t 2012-01-31 00:26:38.258 \N \N \N \N 2012-01-31 00:26:38.258 email@example.com \N 0 sec \N 0 \N \N firstname.lastname@example.org
ERROR: syntax error at or near "1" LINE 376: 1 Firstname Lastname USER t 2012-01-31 00:26:38.258 \N \N \N... ^ ********** Error ********** ERROR: syntax error at or near "1" SQL state: 42601 Character: 9488
I have tried dumping the date with phpPGAdmin and pgAdmin III. Same error in both sql queries.