hi all,
I am using postgres 9.4 on windows 7.
i want import that backup sql file into postgres schema.
i googled i got copy, but when i ran in windows
COPY actor FROM 'c:\users\venu\downloads\sakila-data.sql';
ERROR: invalid input syntax for integer: ""
CONTEXT: COPY actor, line 1, column actor_id: ""
********** Error **********
the backupdata format
COPY actor (actor_id, first_name, last_name, last_update) FROM stdin;
1 PENELOPE GUINESS 2006-02-15 09:34:33
2 NICK WAHLBERG 2006-02-15 09:34:33
3 ED CHASE 2006-02-15 09:34:33
4 JENNIFER DAVIS 2006-02-15 09:34:33
how to import to table from file in postgres
any help..?