Re: [GENERAL] COPY again...
Hi Tony These things can get on ur nerves and it happened in my case too.. In my case the data simply didnt load into the tables becasue the primary keys which were being referenced in the csv file were not present in the file. Thus it never inserted any rows in thetable.. Also even if part of ur feed is incorrect the entire csv file will be rejected without any reason being displayed.. U will have to sort this problems out by going thru samples of ur csv file.. Hope this is of some help Anand On Wed, Mar 07, 2001 at 03:34:24PM +0100, Tony Grant wrote: Gets me every time this one... COPY entreprise FROM '/home/pgsql/data/ENTREP_Tony.csv' USING DELIMITERS '\t'; gives No data returned What is wrong with my data file - .csv file from Gnumeric export? Cheers Tony Grant ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
RE: [GENERAL] COPY again...
If the file is truly CSV (comma separated values), you might want to change DELIMITERS '\t' to DELIMITERS ','... Otherwise, include a couple of lines of data... Robert Creager Senior Software Engineer Client Server Library 303.673.2365 V 303.661.5379 F 888.912.4458 P StorageTek INFORMATION made POWERFUL -Original Message- From: Tony Grant [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 7:34 AM To: [EMAIL PROTECTED] Subject: [GENERAL] COPY again... Gets me every time this one... COPY entreprise FROM '/home/pgsql/data/ENTREP_Tony.csv' USING DELIMITERS '\t'; gives No data returned What is wrong with my data file - .csv file from Gnumeric export? Cheers Tony Grant ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
