Skip site navigation (1) Skip section navigation (2)

Re: Importing data into postgreSQL from FileMaker?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neacal <deb(at)mac(dot)ppc>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Importing data into postgreSQL from FileMaker?
Date: 2004-09-18 19:51:35
Message-ID: 7297.1095537095@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Neacal <deb(at)mac(dot)ppc> writes:
> Can I use textfiles (e.g. tab-separated) to transfer data from
> FileMaker to PostgreSQL??

Tab-separated text files should work fine --- read them with COPY.
(At least, to that level of detail it will work.  You might encounter
some issues with representation of NULLs, or different ideas about
timestamp formatting, or something like that.  I dunno enough about
FileMaker to say.)

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2004-09-18 20:00:26
Subject: Re: DST and time zones
Previous:From: M. BastinDate: 2004-09-18 19:40:05
Subject: Re: Importing data into postgreSQL from FileMaker?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group