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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
