Import question

From: Scobey Weaver <scobey49(at)verizon(dot)net>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Import question
Date: 2020-05-27 20:11:26
Message-ID: 28d53547-8ddb-45d4-2370-cc2069c5933b@verizon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Attachment Content-Type Size
markets.csv text/csv 606 bytes

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Rishabh Kumar 2020-05-27 23:45:30 PG Admin opens in browser
Previous Message Potvin 2020-05-25 11:43:20 RE: Two Factor Authentication and the Query Tool