NEWBIE: How do I use \copy to populate from a flat file

From: Brian Burton-Cundall <lists(at)graith(dot)co(dot)uk>
To: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>
Subject: NEWBIE: How do I use \copy to populate from a flat file
Date: 1999-03-02 11:15:19
Message-ID: 36DBC846.83453B7C@graith.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bas Peters 1999-03-02 11:36:07 FW: indexing functions
Previous Message Nick Urbanik 1999-03-02 08:56:18 Indexes created when insert blobs--problems!