Re: Import question

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 <scobey49(at)verizon(dot)net> 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) <
> Nawaz(dot)Ahmed(at)aus(dot)fujixerox(dot)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 <scobey49(at)verizon(dot)net>
>> Sent: Thursday, 28 May 2020 6:11 AM
>> To: pgadmin-support(at)lists(dot)postgresql(dot)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"
>
>
>

--
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"