RE: [GENERAL] Importing to Postgres from Filemaker Pro

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(at)houstoncellular(dot)com]
> Sent: Monday, February 01, 1999 2:05 PM
> To: 'Adam Haberlach'; pgsql-general(at)postgreSQL(dot)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(at)ricochet(dot)net]
> Sent: Sunday, January 31, 1999 2:50 PM
> To: pgsql-general(at)postgreSQL(dot)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?
>
>