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..?

Responses

  • Re: at 2015-03-03 14:51:38 from Adrian Klaver
  • Re: at 2015-03-03 18:00:08 from Francisco Olarte

Browse pgsql-general by date

  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