From: | Joberlander <Joberlander(at)bluskyconsultants(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Importing CSV from FileMaker to PostgreSQL with PgAdmin III |
Date: | 2016-06-16 00:58:18 |
Message-ID: | 1466038698887-5908065.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
This is sort of a general question here, as I cannot provide the data I am
trying to import. However, I have exported a csv file from Filemaker Pro
Advanced 15 and I am trying to import it into PostgreSQL using PgAdmin III.
When importing this infromation, the progress bar fills and I am presented
the option to click done (I presume the import is done). However, after
clicking "done" and looking in the table, none of the data "imported" is
actually there. I am not sure why this is, I have looked many places and
have also contacted FM. Does anyone here have any suggestions ?
Here is the log for this execution:
2016-06-15 17:40:22 QUERY : COPY query (127.0.0.1:5432):
COPY
public."Clients"(name,"createdAt","updatedAt",age,birthday,canreceivetxt,phone,dln,ssn,zip,scndcntctprsn,casetype,incidentloc,dol,pdp,pr,incidentfcts,posncar,pdd,ymmov,advinfo,wtnsnfo,advtick,clitick,policy,adjstrnme,adjstrphne,adjstrfx,insclaimnum,advpol,advinsn,advinsp,trnsprtbprmdc,whtcmpny,medtrtmnt,prvdrs,doi,rltdclaims,wglss,source,notes,locov,dls,email,cai,advins,address,gender,scndrycntctprsonphone,scndryctnctprsnrel,inslimit,checksreceived,disbursement,clientinssettlesamnt,casefeepercent,advsettleamnt,"Casecost",lineitemfees,lastcall)
FROM STDIN
(FORMAT 'csv', DELIMITER ',', HEADER, QUOTE '"', ESCAPE '"', ENCODING
'UTF8')
--
View this message in context: http://postgresql.nabble.com/Importing-CSV-from-FileMaker-to-PostgreSQL-with-PgAdmin-III-tp5908065.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Moritz Schepp | 2016-06-16 06:29:59 | Re: Collation |
Previous Message | Gavin Flower | 2016-06-15 20:24:35 | Re: pgadmin doesn't see tables - SOLVED |