Importing large data files into PostgreSQL

From: "Elizabeth O'Neill" <elizabeth(dot)o(at)abcmail(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: Importing large data files into PostgreSQL
Date: 2001-11-14 18:38:24
Message-ID: C959CDB1-D92E-11D5-8F15-0030654C3134@abcmail.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi i hope some one can help i'm new to PostgreSQL i have been trying to
load data into a table using the "\Copy" function. All the records
(approx. 15,000) will go into the table but the it doesn't seem to
reconise the delimiters because the data is randomly split over the
columns in the table.

I have tried changing the size of the columns, making sure the
delimiters are correct, changing the delimiters to "," instead of
"<TAB>", inserting a small section of the data and changing the
data-types of the columns from 'varchar' to 'char' but none of this
makes a difference

Does anyone know what may be wrong or a better way to import large
chunks of data.

Please help before i go bald from pulling my hair out

Thank you in advance

Liz

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jayesh K. Parayali 2001-11-14 20:49:54 Re: [JDBC] PostgreSQL->JDBC->Tomcat->Apache resource uses
Previous Message Phill Kenoyer 2001-11-14 17:11:53 Re: installing