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: | Raw Message | Whole Thread | 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 |