On 24/10/2011 20:23, Allan Kamau wrote: > Hi, > I have a tab delimited file with over a thousand fields (columns) > which I would like to import into postgreSQL. > > I have opted to import the entire record (line) of this file into a > single field in a table, one table record per file line. Later split > the contents of the field accordingly into an array for further > processing and decomposition. > > I am using the COPY command as follows > #COPY a.t(raw_data)FROM '/data/tmp/t.txt'; > > and it reports "ERROR: extra data after last expected column". I'd guess that there's a character in the input which PG is interpreting as a column delimiter. Use the WITH DELIMITER option to set the expected delimiter to something that won't appear in the input. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
