Hi Scobey, Can you please share the table DDL with some sample records CSV to simulate the issue at our end ?
On Thu, May 28, 2020 at 11:13 AM Scobey Weaver <[email protected]> wrote: > Dear Aditya, > > I did click on more details. I've attached a screen shot of the result. > > Thanks, > > Scobey > > On 5/28/20 12:06 AM, Aditya Toshniwal wrote: > > Hi Scobey, > > Did you click on more details on the import progress notifier ? It would > give you more logs to help. > > On Thu, May 28, 2020 at 6:52 AM Ahmed, Nawaz (Fuji Xerox Australia) < > [email protected]> wrote: > >> Are you running this import into a database in Linux environment or a >> Windows environment ? >> >> I am guessing (I could be wrong), it has something to do with control >> characters in your datafile such as ^M or ^H, which are usually visible if >> you edit the file in a Linux host using 'vi' editor. >> >> And what is the import command are you using, is it a COPY command ? >> >> ~ >> >> Nawaz >> >> >> -----Original Message----- >> From: Scobey Weaver <[email protected]> >> Sent: Thursday, 28 May 2020 6:11 AM >> To: [email protected] >> Subject: Import question >> >> I'm taking a skillshare course and creating my own tables. I tried to >> import some data from a csv file and it didn't work. I thought I had done >> it just like the example on the video, and also checked some other online >> sources which seemed to do it the same way. >> >> Attached is the file I'm trying to import. >> >> The table I'm importing to was created as follows: >> >> CREATE TABLE public.markets >> ( >> id integer NOT NULL, >> "Market" character varying(50) COLLATE pg_catalog."default" NOT NULL, >> CONSTRAINT markets_pkey PRIMARY KEY (id), >> CONSTRAINT unique_market UNIQUE ("Market") >> ) >> >> TABLESPACE pg_default; >> >> ALTER TABLE public.markets >> OWNER to postgres; >> COMMENT ON TABBLE public.markets >> IS 'Market used as the price index (posted, Platts, Opis, Argus, >> etc...)'; >> >> The import fails with the following error: Failed (exit code -6) >> >> I can't find "exit code -6" anywhere. What's wrong with my import? >> >> I've had one reply to this that brought up encoding. I left the encoding >> blank at first, as did the instructor in the skillshare video. Since then >> I've tried the UTF8 suggested by the person who brought it up. I also >> tried BIG5, EUC_CN, SQL_ASCII and WIN1250. >> >> All efforts ended with the same result. Is there a list of exit codes >> anywhere? What's "exit code -6"? >> >> Thanks, >> >> Scobey >> >> >> >> >> >> >> >> IMPORTANT NOTE: Fuji Xerox email transmission, including any attachments, >> is private and confidential and may contain legally privileged information. >> It is for the addressee's attention only. If you are not the intended >> recipient and have received this transmission, you must not use, edit, >> print, copy or disclose its contents to any person or disseminate the >> information contained herein or hereto attached, and you must notify sender >> immediately by return email and delete this transmission from your system. >> Any confidentiality, privilege or copyright is not waived or lost because >> this e-mail has been sent to you in error. We have used reasonable efforts >> to protect this transmission from computer viruses and other malicious >> software, but no warranty is made and the sender takes no responsibility >> for any loss or damage incurred from using this email or the information >> contained in this email. >> > > > -- > Thanks and Regards, > Aditya Toshniwal > pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune > "Don't Complain about Heat, Plant a TREE" > > > -- Thanks and Regards, Aditya Toshniwal pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune "Don't Complain about Heat, Plant a TREE"
