Dear Nawaz,
I'm running it on a macbook pro. I'm familiar with vi, but I'm not sure
if it's available for mac or if there's something else similar.
The file attached is the one I imported, however, so you can check it
for me if you like. I'm assuming it wouldn't be any different to you
than it was to pgadmin.
I used the import/export wizard that's launched by right clicking on the
table name and selecting import/export. I did see that the query it
runs is a copy, however.
Thanks,
Scobey
On 5/27/20 9:22 PM, Ahmed, Nawaz (Fuji Xerox Australia) 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.