From: Klas Stockhem <Klas.Stockhem@benders.se>
To: Richard Huxton <dev@archonet.com>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Problems when copy data from dump file
Date: Thu, 6 Aug 2009 12:00:46 +0200
Message-ID: <2A250781A3744D48B1529FCC3C2EB8ABCB4934@comserver.benders.se> (raw)
> The data in the dump file are structured and I want to execute this
> automatically (copy+paste it) in the EMS software.
> I still get the syntax error even if I use the command you send me:
> COPY artikkel (id, tittel, tekst) FROM stdin; 1<tab>Title
one<tab>Some
> text \.
Why not just load the dump file into PostgreSQL? Why are you trying to
copy+paste if you want the entire dump?
--
Richard Huxton
Archonet Ltd
>
>
>
I have tried to load the dump file also but get same error.
I have check the sql dump file in Ultra editor 32 where you can see the
hex value of each character in the file I see the both the original dump
file and my copy+paste text contain a tab (hex value 09).
Note that I have "CREATE TABLE" script in the dump file and this was
executed good in the server. This was copy+pasted also.
Maybe you can send me an create table script and one row of a copy
command and I can execute this and see if it works?
//Klas
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Klas.Stockhem@benders.se, dev@archonet.com
Subject: Re: Problems when copy data from dump file
In-Reply-To: <2A250781A3744D48B1529FCC3C2EB8ABCB4934@comserver.benders.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox