COPY FROM - force a value

From: "Demel, Jeff" <Jeff(dot)Demel(at)JavelinDirect(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: COPY FROM - force a value
Date: 2007-02-08 19:13:00
Message-ID: 136ED738BD4F1545B97E4AC06FF6370734C296@DMSP-MSG-EVS01.mail.pvt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is there a way to force a value when you're doing a COPY FROM, importing
a file into a table?

Here's my query as it is now:

COPY filetable (value1, value2, value3, value4, forcevalue1,
forcevalue2)
FROM 'C:\\InsertFiles\\thisfile.txt'
WITH DELIMITER AS ' '
;

The file only contains data for values 1 through 4. I'd like to insert
values for the last two fields. This is what I had in mind, which
doesn't work:

COPY filetable (value1, value2, value3, value4, forcevalue1,
forcevalue2)
FROM 'C:\\InsertFiles\\thisfile.txt'
WITH DELIMITER AS ' ',
forcevalue1 = 1,
forcevalue2 = 'this value'
;

TIA

-Jeff
This email is intended only for the individual or entity to which it is addressed. This email may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this e-mail or any attachments by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is prohibited. If you are not the intended recipient of this message or the employee or agent responsible for delivery of this email to the intended recipient, please notify the sender by replying to this message and then delete it from your system. Any use, dissemination, distribution, or reproduction of this message by unintended recipients is strictly prohibited and may be unlawful.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Klugmann 2007-02-08 19:18:56 unsubscribe
Previous Message Ezequias Rodrigues da Rocha 2007-02-08 17:42:11 Re: Open a Transaction