Import question
От | Scobey Weaver |
---|---|
Тема | Import question |
Дата | |
Msg-id | 28d53547-8ddb-45d4-2370-cc2069c5933b@verizon.net обсуждение исходный текст |
Ответы |
RE: Import question
|
Список | 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
Вложения
В списке pgadmin-support по дате отправления: