| From: | Ramesh T <rameshparnanditech(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | |
| Date: | 2015-03-03 12:39:19 |
| Message-ID: | CAK8Zd=tpM=GdtCH9UwAnqm-6=cikEDCArrWJhHz64Ek_fNPAUw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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..?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hailong Li | 2015-03-03 12:52:07 | Re: The slave suddenly stopped with such DB log : "will not overwrite a used ItemId" and "heap_insert_redo: failed to add tuple" |
| Previous Message | Andres Freund | 2015-03-03 11:26:22 | Re: shared_buffers formula |