RE: [GENERAL] Importing to Postgres from Filemaker Pro - Mailing list pgsql-general

From Jackson, DeJuan
Subject RE: [GENERAL] Importing to Postgres from Filemaker Pro
Date
Msg-id F10BB1FAF801D111829B0060971D839F637FCB@cpsmail
Whole thread Raw
List pgsql-general
Look at the COPY utility in the pgsql/bin dir and the COPY sql command
under psql...
    -DEJ

> -----Original Message-----
> From: Greg Youngblood [mailto:YoungblG@houstoncellular.com]
> Sent: Monday, February 01, 1999 2:05 PM
> To: 'Adam Haberlach'; pgsql-general@postgreSQL.org
> Subject: RE: [GENERAL] Importing to Postgres from Filemaker Pro
>
>
> ODBC may be a solution.
>
> I dont know if Filemaker supports ODBC, but if it does you
> can open the
> database in Filemaker and connect to postgres via ODBC and
> move the data to
> postgres that way.
>
> Gregory S. Youngblood
> ext 2164
>  
>  
>
>
> -----Original Message-----
> From: Adam Haberlach [mailto:haberlaa@ricochet.net]
> Sent: Sunday, January 31, 1999 2:50 PM
> To: pgsql-general@postgreSQL.org
> Subject: [GENERAL] Importing to Postgres from Filemaker Pro
>
>
>     Has anyone out there done any work getting data from
> a FileMaker database into postgres?  I have about 16000 fairly
> large records that I need to move from a crufty MacOS machine
> to a Linux box.  I also have Filemaker for NT handy, as well
> as Lasso.  At least four of the fields in the database can
> contain commas, tabs, and many other simple delimiters.
>     Right now it looks like I may have to export from
> Filemaker into a giant HTML table, and then parse that into
> a bunch of INSERT commands with a special program.
>
>     In short: anyone have any simple tools to import
> complex .csv, .tab or other common flat files into postgres?
>
>

pgsql-general by date:

Previous
From: Sebestyen Zoltan
Date:
Subject: How to compile Postgres with shared library support?
Next
From: Bob Dusek
Date:
Subject: Cost: Big Tables vs. Organized Separation of Data