Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems when copy data from dump file - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Problems when copy data from dump file
Date
Msg-id 4A7A975E.8050403@archonet.com
Whole thread Raw
In response to Problems when copy data from dump file  ("Klas Stockhem" <Klas.Stockhem@benders.se>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Problems when copy data from dump file
Next
From: John
Date:
Subject: Re: two records per row from query