Thread: Have a question

Have a question

From
Michelle Murrain
Date:
Hi Folks,

I've been asked to write a little document for the docs on converting
FileMaker Pro databases into Postgres. I've a question:

Is there a tool out there to convert .dbf files to SQL? I don't know much
about .dbf format - does it include field definitions? If so, is there
documentation out there that people know about on what those definitions look
like, and how they compare to SQL in general (or postgresql in particular)?

TIA,

Michelle
--
------------
Michelle Murrain, Ph.D.
President
Norwottuck Technology Resources
mpm@norwottuck.com
http://www.norwottuck.com

Re: Have a question

From
Bruce Momjian
Date:
[ Charset ISO-8859-2 unsupported, converting... ]
> Hi Folks,
>
> I've been asked to write a little document for the docs on converting
> FileMaker Pro databases into Postgres. I've a question:
>
> Is there a tool out there to convert .dbf files to SQL? I don't know much
> about .dbf format - does it include field definitions? If so, is there
> documentation out there that people know about on what those definitions look
> like, and how they compare to SQL in general (or postgresql in particular)?

Yes, there is a dbf conversion tool.  Not sure of the name though.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

RE: Have a question

From
"Trewern, Ben"
Date:

There is a debian app called dbf2sql which may do what you need, I think it does specific pg stuff as well :-)

Regards

Ben

> -----Original Message-----
> From: Michelle Murrain [mailto:mpm@norwottuck.com]
> Sent: 10 April 2001 01:13
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Have a question
>
>
> Hi Folks,
>
> I've been asked to write a little document for the docs on converting
> FileMaker Pro databases into Postgres. I've a question:
>
> Is there a tool out there to convert .dbf files to SQL? I
> don't know much
> about .dbf format - does it include field definitions? If so,
> is there
> documentation out there that people know about on what those
> definitions look
> like, and how they compare to SQL in general (or postgresql
> in particular)?
>
> TIA,
>
> Michelle
> --
> ------------
> Michelle Murrain, Ph.D.
> President
> Norwottuck Technology Resources
> mpm@norwottuck.com
> http://www.norwottuck.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

*****************************************************************************
This email and any attachments transmitted with it are confidential
and intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the sender and do not store, copy or disclose the content
to any other person.

It is the responsibility of the recipient to ensure that opening this
message and/or any of its attachments will not adversely affect
its systems. No responsibility is accepted by the Company.
*****************************************************************************