This sounds like a question for a PostgreSQL tech support forum.. PgAdmin III is not a native FM application nor is is part of the FM import functionality.
Next time you might want to ask a simple question or a put simple problem statement in the TITLE of posts on this forum.
Trying to put the entire post in the title will drastically reduce the number of constructive replys.
Try removing "HEADER" option. csv don't have header. But the csv have only one record??
What Kris said
Put a simple question in the header and the context in the body...
Are you sure its UTF-8?? FileMaker exports as UTF-16 AFAIK...
not sure why my reply at 7:30 didn't post. here 'tis:
Howdy, JR. can you clarify "exports as UTF-16 AKAIK"? specifically the 'exports' part. Exports with what method? or is this "published" (such as ODBC)? OP says
have exported a csv file from Filemaker
so, it may depend on the selections in the export dialog (from help for Exporting data from FileMaker Pro):
If necessary, for Output file character set, choose the character encoding you want the exported file to use.
You may not need to change the character set selection. FileMaker Pro automatically selects a suitable character set based on the file format you’re exporting to and the operating system you’re using.
So, perhaps you are asking OP to verify the 'character set' in the dialog?
And the .csv has no headers, but the .mer can be used to include headers, just change the extension to .csv