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