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) < nawaz.ah...@aus.fujixerox.com> 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 <scobe...@verizon.net> > Sent: Thursday, 28 May 2020 6:11 AM > To: pgadmin-support@lists.postgresql.org > 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"