On Tue, Dec 7, 2010 at 2:14 PM, Raymond O'Donnell <rod@xxxxxx> wrote: > On 07/12/2010 11:07, Allan Kamau wrote: >> >> 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' >> ; > > You can specify the character which COPY sees as the field delimiter to be > something other than a tab - maybe a comma, if there are no commas in your > input: > > copy raw_data(raw_record) > from '/tmp/some.tsv' > with delimiter ','; > > Would that do the job? > > Ray. > > -- > Raymond O'Donnell :: Galway :: Ireland > rod@xxxxxx > There are commas in the input, and there is no guarantee that any one single character will not appear in the input. I could appoint a character such as the comma as suggested then use sed to change all commas in the incoming data to maybe '|' (pipe character) but this it may change the semantics of the data if the incoming data does contain pipe characters delimiting comma separated lists of values all in a given logical field. Allan. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
