From: Paul Lambert <paul.lambert@autoledgers.com.au>
To: pgsql-sql@postgresql.org
Subject: Query RE using COPY
Date: Tue, 08 May 2007 09:51:52 +0800
Message-ID: <463FD7B8.9030700@autoledgers.com.au> (raw)
I use the COPY command to load data from a file into tables in my database.
The following is an example done in psql:
COPY deals_temp_load FROM 'c:/temp/autodrs_deals.txt' WITH DELIMITER AS
'^' QUOTE '\f' CSV HEADER;
If a column is added to the table but has not been added to the extracts
which create the autodrs_deals.txt file, this errors thusly:
ERROR: missing data for column "location"
CONTEXT: COPY deals_temp_load, line 2: "line containing data removed
for confidentiality - suffice to say it does not contain the 'location'
column"
Is there any way of telling it to ignore columns that have not been
specified in the file used to load? I have tried giving the column a
default value but I still get the error. The column in this case
'location' is a nullable column and does not always have data (yes, bad
design for a database, but we'll skip that point for now) thus I am not
concerned if the load procedure doesn't supply it.
BTW, this is done on Weendoze.
Thanks,
Paul.
--
Paul Lambert
Database Administrator
AutoLedgers
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: paul.lambert@autoledgers.com.au
Subject: Re: Query RE using COPY
In-Reply-To: <463FD7B8.9030700@autoledgers.com.au>
* 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