Importing CSV from FileMaker to PostgreSQL with PgAdmin III

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.

Browse pgsql-novice by date

  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