From: Richard Huxton <dev@archonet.com>
To: Klas Stockhem <Klas.Stockhem@benders.se>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: Problems when copy data from dump file
Date: Thu, 06 Aug 2009 09:42:06 +0100
Message-ID: <4A7A975E.8050403@archonet.com> (raw)
In-Reply-To: <2A250781A3744D48B1529FCC3C2EB8ABCB48FF@comserver.benders.se>
References: <2A250781A3744D48B1529FCC3C2EB8ABCB48FF@comserver.benders.se>
Klas Stockhem wrote:
> 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
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: dev@archonet.com, Klas.Stockhem@benders.se
Subject: Re: Problems when copy data from dump file
In-Reply-To: <4A7A975E.8050403@archonet.com>
* 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