Re: Problems when copy data from dump file

From: Richard Huxton <dev(at)archonet(dot)com>
To: Klas Stockhem <Klas(dot)Stockhem(at)benders(dot)se>
Cc: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problems when copy data from dump file
Date: 2009-08-06 08:42:06
Message-ID: 4A7A975E.8050403@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Verheyden 2009-08-06 09:09:19 trigger problem
Previous Message Klas Stockhem 2009-08-06 08:39:46 Re: Problems when copy data from dump file