Copying entire tsv record (from file) into a single field

From: Allan Kamau <kamauallan(at)gmail(dot)com>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Copying entire tsv record (from file) into a single field
Date: 2010-12-07 11:07:19
Message-ID: AANLkTimiZa1t-hidDUKufi_aR2aVjQ2b8QYAyaWoh8mD@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would like to use copy to populate a single row in table with data
from a tsv file for further transformations.
I seem not find a way to stop copy from seeing that the tsv file does
indeed contain fields.
This my current query

COPY raw_data
(
raw_record
)
FROM
'/tmp/some.tsv'
;

Allan.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raimon Fernandez 2010-12-07 11:11:27 SELECT is immediate but the UPDATE takes forever
Previous Message Grzegorz Jaśkiewicz 2010-12-07 10:13:41 Re: if-clause to an exiting statement