Postgres Pro
Downloads
Home   >   mailing lists

NEWBIE: How do I use \copy to populate from a flat file - Mailing list pgsql-general

From Brian Burton-Cundall
Subject NEWBIE: How do I use \copy to populate from a flat file
Date
Msg-id 36DBC846.83453B7C@graith.co.uk
Whole thread Raw
Responses Re: [GENERAL] NEWBIE: How do I use \copy to populate from a flat file
List pgsql-general
Tree view 
I've used mSQL before and managed to import flat files exported from MS Access
(needs must) into that. I need to import flat files into PostGreSQL. I've
created the table using psql - POSTGRESQL interactive sql monitor:

I can see the command from the help
 \copy table {from | to} <fname>

I've got a flat file with TAB separated values that match the table but when I
use
\copy ENTRY from /u1/www/intranet/brian/ENTRY.txt

I get
Broken Pipe

and it returns to the shell prompt. Any ideas?

(I don't want to have to create 20,000+ INSERT  SQL commands or even automate
it)

Thanks
Brian
Graith Internet - http://www.graith.co.uk

pgsql-general by date:

Previous
From: Nick Urbanik
Date:
Subject: Indexes created when insert blobs--problems!
Next
From: Bas Peters
Date:
Subject: FW: indexing functions